{"text_format":"1","workbook":"xlsx","n_sheets":14,"sheets":["Index -->","Index","1. P&L extractions -->","1.1 FY2011","1.2 FY2012","1.3 FY2013","2. Building a P&L -->","2.1 Database","2.2 P&L statement","3. Charts -->","3.1 Column stacked chart","3.2 Dougnut chart","3.3 Area & line chart","3.4 Bridge Chart"],"not_rendered":{"charts":7,"images":0,"macros":1,"external_links":1,"defined_names":4,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Index -->","index":0,"n_rows":12,"n_cols":2,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Index  -->"]

{"sheet":"Index","index":1,"n_rows":17,"n_cols":4,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
[null,"Case study: Create a P&L from scratch"]
[null,"Sheet index"]
[]
[null,"#                ","Worksheet","Notes"]
[null,1,"Index"]
[null,2,"1. P&L extractions -->"]
[null,3,{"$f":"+\"1.1 \"&'1.1 FY2011'!C1","v":"1.1 FY2011"}]
[null,4,{"$f":"\"1.2 \"&'1.2 FY2012'!B1","v":"1.2 FY2012"}]
[null,5,{"$f":"\"1.3 \"&'1.3 FY2013'!B1","v":"1.3 FY2013"}]
[null,6,"2. Building a P&L -->"]
[null,7,{"$f":"+\"2.1 \"&'2.1 Database'!B1","v":"2.1 Database"}]
[null,8,{"$f":"+\"2.2 \"&'2.2 P&L statement'!B1","v":"2.2 P&L statement"}]
[null,19,"3. Charts -->"]
[null,20,{"$f":"+\"3.1 \"&'3.1 Column stacked chart'!B1","v":"3.1 Column stacked chart"}]
[null,21,{"$f":"+\"3.2 \"&'3.2 Dougnut chart'!B1","v":"3.2 Doughnut chart"}]
[null,22,{"$f":"\"3.3 \"&'3.3 Area & line chart'!B1","v":"3.3 Area & Line chart"}]
[null,23,{"$f":"+\"3.4 \"&'3.4 Bridge Chart'!B1","v":"3.4 Bridge chart"}]

{"sheet":"1. P&L extractions -->","index":2,"n_rows":12,"n_cols":2,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"1. P&L extractions -->"]

{"sheet":"1.1 FY2011","index":3,"n_rows":62,"n_cols":7,"rows_kept":62,"cut":false,"hidden":false,"merged":[]}
[null,null,"FY2011"]
[]
[]
[null,"Code","P&L account","Partner company","Name of partner company","Amounts","Account number"]
[null,"2001110000111111","Core business revenues",111111,"External",-14500341,2001110000]
[null,"2001190000111111","Other revenues",111111,"External",-4794856.1919999998,2001190000]
[null,"20200000001009","Capitalized costs",1009,"Green Ventures Ltd",-154890.4,2020000000]
[null,"20200000001007","Capitalized costs",1007,"Generco Sunshine JSC",-1180894.0520000001,2020000000]
[null,"20200000001008","Capitalized costs",1008,"Greenco Ltd",-793079.51199999999,2020000000]
[null,"2020000000111101","Capitalized costs",111101,"Not assigned",-2277197.6,2020000000]
[null,"2021900000111111","Direct costs",111111,"External",4428911.7640000004,2021900000]
[null,"2024080000111111","Freight outbound expenses",111111,"External",16977.628000000001,2024080000]
[null,"202409000088","R&D expenses",88,"Generco Ltd",2245437.54,2024090000]
[null,"2024090000111111","R&D expenses",111111,"External",16605.634000000002,2024090000]
[null,"2041000000111111","Wages and salaries",111111,"External",4683394.0460000001,2041000000]
[null,"2042000000111101","Pension contributions",111101,"Not assigned",1143051.5760000001,2042000000]
[null,"204200000088","Pension contributions",88,"Generco Ltd",239379.61800000002,2042000000]
[null,"2045000000111101","Severance indemnity contribution",111101,"Not assigned",104913.8,2045000000]
[null,"2051210000111101","D&A",111101,"Not assigned",2003262.2180000001,2051210000]
[null,"2051260000111101","D&A",111101,"Not assigned",41981.296000000002,2051260000]
[null,"20690100001","Corporate recharges","1","Greeny Ltd",-2156147.4,2069010000]
[null,"206901000014","Corporate recharges",14,"Generco Cosmetics Ltd",-291428.55199999997,2069010000]
[null,"20690100001037","Corporate recharges",1037,"Generco Canada JSC",0,2069010000]
[null,"20690100001087","Corporate recharges","1087","Gener Beauty GmbH",-33736.5,2069010000]
[null,"20690100001009","Corporate recharges",1009,"Green Ventures Ltd",0,2069010000]
[null,"20690100001007","Corporate recharges",1007,"Generco Sunshine JSC",0,2069010000]
[null,"20690100001008","Corporate recharges",1008,"Greenco Ltd",0,2069010000]
[null,"20690100001240","Corporate recharges",1240,"Generco UK ",-199600.4,2069010000]
[null,"2069010000111111","Corporate recharges",111111,"External",-539141.4,2069010000]
[null,"2069980000111111","Other income",111111,"External",-57.221999999999994,2069980000]
[null,"2070400000111111","Marketing expenses",111111,"External",22314.879999999997,2070400000]
[null,"207050000088","Software&IT",88,"Generco Ltd",204000,2070500000]
[null,"2070500000111111","Software&IT",111111,"External",138.41399999999999,2070500000]
[null,"2070600000111111","Leasings",111111,"External",1127445.872,2070600000]
[null,"207090000043","Service expenses","43","Greeny France SL",133722,2070900000]
[null,"20709000002240","Service expenses","2240","Greeny Germany GmbH",328061.886,2070900000]
[null,"2070900000111111","Service expenses",111111,"External",2081304.3219999997,2070900000]
[null,"2071000000111111","Charges and contributions",111111,"External",33410.031999999999,2071000000]
[null,"2071100000111111","Insurance expenses",111111,"External",213090.85199999998,2071100000]
[null,"2071209200111111","Travel expenses",111111,"External",1813525.004,2071209200]
[null,"2071209400111111","Utility expenses",111111,"External",5552.2,2071209400]
[null,"2071209500111111","Legal expenses",111111,"External",43868.975999999995,2071209500]
[null,"2071980000111101","Misc costs",111101,"Not assigned",10934.671999999999,2071980000]
[null,"2079022000111111","Consulting fees",111111,"External",20400,2079022000]
[null,"2079070000105","Misc extraordinary expenses",105,"Generco Healthcare Ltd",0,2079070000]
[null,"2079070000111111","Misc extraordinary expenses",111111,"External",563918.152,2079070000]
[null,"20790800001009","Difference from eliminations",1009,"Green Ventures Ltd",0,2079080000]
[null,"20790800001007","Difference from eliminations",1007,"Generco Sunshine JSC",0,2079080000]
[null,"20790800001008","Difference from eliminations",1008,"Greenco Ltd",0,2079080000]
[null,"20822800001009","Interest income",1009,"Green Ventures Ltd",0,2082280000]
[null,"20822800001007","Interest income",1007,"Generco Sunshine JSC",0,2082280000]
[null,"20822800001008","Interest income",1008,"Greenco Ltd",0,2082280000]
[null,"20822800001240","Interest income",1240,"Generco UK ",-35810.228000000003,2082280000]
[null,"2082280000111111","Interest income",111111,"External",-51927.417999999998,2082280000]
[null,"2082202000111101","Capitalized interest",111101,"Not assigned",-862270.63399999996,2082202000]
[null,"2082208200111101","Non-recurring costs",111101,"Not assigned",22763,2082208200]
[null,"208221400088","Interest expenses",88,"Generco Ltd",2930430.0120000001,2082214000]
[null,"2091200000111101","Current taxes",111101,"Not assigned",-49378.641999999993,2091200000]
[null,"2091200001111101","Regional taxes",111101,"Not assigned",516250.67,2091200001]
[null,"2092200000111101","Deferred taxes",111101,"Not assigned",21593.093999999997,2092200000]
[null,"2999999999111101","Net income/(loss)",111101,"Not assigned",{"$f":"SUM(F5:F60)","v":-2904117.9939999986},2999999999]
[null,"x"]

{"sheet":"1.2 FY2012","index":4,"n_rows":86,"n_cols":7,"rows_kept":86,"cut":false,"hidden":false,"merged":[]}
[null,"FY2012"]
[]
[]
[null,"Code","P&L account","Partner company","Name of Partner company","Amount","Account number"]
[null,"2001110000105","Core business revenues",105,"Generco Healthcare Ltd",-355396.61499999999,2001110000]
[null,"2001110000111111","Core business revenues",111111,"External",-15792898.75,2001110000]
[null,"2001190000111111","Other revenues",111111,"External",-6960217.6449999996,2001190000]
[null,"20200000001086","Capitalized costs","1086","G&Resources Ltd",-420017.14999999997,2020000000]
[null,"20200000001007","Capitalized costs",1007,"Generco Sunshine JSC",-89234.880000000005,2020000000]
[null,"20200000001008","Capitalized costs",1008,"Greenco Ltd",-26173,2020000000]
[null,"2020000000111101","Capitalized costs",111101,"Not assigned",-209401.92,2020000000]
[null,"2021210000111111","Utility charges",111111,"External",14589.33,2021210000]
[null,"2021900000111111","Direct costs",111111,"External",5463188.8250000002,2021900000]
[null,"2024080000111111","Freight outbound expenses",111111,"External",343675,2024080000]
[null,"202409000019","R&D expenses",19,"Generco Cosmetics Ltd",38521,2024090000]
[null,"202409000088","R&D expenses",88,"Generco Ltd",1980162.23,2024090000]
[null,"20240900001283","R&D expenses","1283","Generco Ventures Ltd",1820,2024090000]
[null,"20240900001924","R&D expenses","1924","Generco Infrastructure Ltd",10448.129999999999,2024090000]
[null,"20240900002486","R&D expenses","2486","Generco Exloration Ltd",10412.5,2024090000]
[null,"2024090000111111","R&D expenses",111111,"External",27148.625,2024090000]
[null,"2041000000111111","Wages and salaries",111111,"External",5507141.0549999997,2041000000]
[null,"2042000000111101","Social security payments",111101,"Not assigned",1752994.18,2042000000]
[null,"2042000000111101","Pension contributions",111101,"Not assigned",304303.86000000004,2042000000]
[null,"2045000000111101","Severance indemnity contribution",111101,"Not assigned",500500,2045000000]
[null,"2049000000111101","Other personnel expenses",111101,"Not assigned",6919.8499999999995,2049000000]
[null,"2051210000111101","D&A",111101,"Not assigned",1897676.87,2051210000]
[null,"2051260000111101","D&A",111101,"Not assigned",146328.94499999998,2051260000]
[null,"2060220000111111","Gains from disposal of PP&E",111111,"External",-121553.07499999998,2060220000]
[null,"20690100001","Corporate recharges","1","Greeny Ltd",-1643711.145,2069010000]
[null,"206901000019","Corporate recharges",19,"Generco Cosmetics Ltd",-416278.66,2069010000]
[null,"20690100001076","Corporate recharges","1076","Generco Trading Ltd",-364243.84499999997,2069010000]
[null,"20690100001086","Corporate recharges","1086","G&Resources Ltd",0,2069010000]
[null,"20690100001009","Corporate recharges",1009,"Green Ventures Ltd",0,2069010000]
[null,"20690100001007","Corporate recharges",1007,"Generco Sunshine JSC",0,2069010000]
[null,"20690100001008","Corporate recharges",1008,"Greenco Ltd",0,2069010000]
[null,"20690100001240","Corporate recharges",1240,"Generco UK ",-10461.36,2069010000]
[null,"20690100001007","Corporate recharges",1007,"Generco Semiconductors Ltd",0,2069010000]
[null,"206901000047037","Corporate recharges","47037","G&CR Global Ltd",-482611.04499999998,2069010000]
[null,"2069010000111111","Corporate recharges",111111,"External",-6785.94,2069010000]
[null,"206998000088","Other income",88,"Generco Ltd",-2436.35,2069980000]
[null,"2069980000111111","Other income",111111,"External",9793.84,2069980000]
[null,"2070290000111101","Concession fees other",111101,"Not assigned",81.339999999999989,2070290000]
[null,"2070400000111111","Marketing expenses",111111,"External",65947.7,2070400000]
[null,"2070500000111111","Software&IT",111111,"External",5138.91,2070500000]
[null,"2070600000111111","Leasings",111111,"External",1055381.4750000001,2070600000]
[null,"20709000002240","Service expenses","2240","Greeny Germany GmbH",430845.34499999997,2070900000]
[null,"2070900000105","Service expenses",105,"Generco Healthcare Ltd",276920,2070900000]
[null,"2070900000111111","Service expenses",111111,"External",1130021,2070900000]
[null,"2071000000111111","Charges and contributions",111111,"External",7293.5450000000001,2071000000]
[null,"20711000001900","Insurance expenses",1900,"Generco Metals Gm",0,2071100000]
[null,"2071100000111111","Insurance expenses",111111,"External",48468.665000000001,2071100000]
[null,"20712092001118","Travel expenses","1118","Gener Green LLC",23928.799999999999,2071209200]
[null,"2071209200111111","Travel expenses",111111,"External",2393259.19,2071209200]
[null,"2071209400111111","Utility expenses",111111,"External",23069.654999999999,2071209400]
[null,"2071209500111111","Legal expenses",111111,"External",208366.935,2071209500]
[null,"2071220000111111","Losses fr disposal of PPE",111111,"External",308232,2071220000]
[null,"207151100019","Other operative currency differences",19,"Generco Cosmetics Ltd",13422.779999999999,2071511000]
[null,"2071511000111111","Other operative currency differences",111111,"External",4045.6150000000002,2071511000]
[null,"2071910000111111","Property tax",111111,"External",49621.144999999997,2071910000]
[null,"2071980000111101","Misc costs",111101,"Not assigned",20323.309999999998,2071980000]
[null,"2079022000111111","Consulting fees",111111,"External",169489,2079022000]
[null,"207907000019","Misc extraordinary expenses",19,"Generco Cosmetics Ltd",85462.684999999998,2079070000]
[null,"207907000043","Misc extraordinary expenses","43","Greeny France SL",11422.144999999999,2079070000]
[null,"20790700001924","Misc extraordinary expenses","1924","Generco Infrastructure Ltd",84438.864999999991,2079070000]
[null,"2079070000111111","Misc extraordinary expenses",111111,"External",638869.13,2079070000]
[null,"20790800001086","Difference from eliminations","1086","G&Resources Ltd",0,2079080000]
[null,"20790800001007","Difference from eliminations",1007,"Generco Sunshine JSC",0,2079080000]
[null,"20790800001008","Difference from eliminations",1008,"Greenco Ltd",0,2079080000]
[null,"20822800001086","Interest income","1086","G&Resources Ltd",0,2082280000]
[null,"20822800001009","Interest income",1009,"Green Ventures Ltd",0,2082280000]
[null,"20822800001007","Interest income",1007,"Generco Sunshine JSC",0,2082280000]
[null,"20822800001008","Interest income",1008,"Greenco Ltd",0,2082280000]
[null,"20822800001240","Interest income",1240,"Generco UK ",-34224.959999999999,2082280000]
[null,"20822800001006","Interest income",1006,"Generco Mining GmbH",-6778.415,2082280000]
[null,"20822800001007","Interest income",1007,"Generco Semiconductors Ltd",0,2082280000]
[null,"2082280000111111","Interest income",111111,"External",-2204.7199999999998,2082280000]
[null,"2082208200111101","Non-recurring costs",111101,"Not assigned",80617.179999999993,2082208200]
[null,"208221400088","Interest expenses",88,"Generco Ltd",2752704.22,2082214000]
[null,"20822140001007","Interest expenses",1007,"Generco Semiconductors Ltd",0,2082214000]
[null,"2082214000111111","Interest expenses",111111,"External",1250.7950000000001,2082214000]
[null,"20821100001240","Impairment of participation",1240,"Generco UK ",4130000,2082110000]
[null,"2091200000111101","Current taxes",111101,"Not assigned",496748.70000000007,2091200000]
[null,"2091200001111101","Regional taxes",111101,"Not assigned",480872.96000000002,2091200001]
[null,"2091900000111101","Quarterly changes in current taxes",111101,"Not assigned",0,2091900000]
[null,"2092200000111101","Deferred taxes",111101,"Not assigned",6570.3050000000003,2092200000]
[null,"2111111999111101","Net income/(loss)",111101,"Not assigned",6073808.1600000001,2111111999]

{"sheet":"1.3 FY2013","index":5,"n_rows":78,"n_cols":7,"rows_kept":78,"cut":false,"hidden":false,"merged":[]}
[null,"FY2013"]
[]
[]
[null,"Code","P&L account","Partner company","Name of Partner company","Amount","Account Number"]
[null,"2001110000105","Core business revenues",105,"Generco Healthcare Ltd",-616462.01899999997,2001110000]
[null,"2001110000111111","Core business revenues",111111,"External",-14431341,2001110000]
[null,"2001190000111111","Other revenues",111111,"External",-6373617.5140000004,2001190000]
[null,"2021210000111111","Utility charges ",111111,"External",20504.509999999998,2021210000]
[null,"2021900000111111","Direct costs",111111,"External",5674152.0669999998,2021900000]
[null,"2024020000111111","Operating expenses for utilities",111111,"External",13691.949999999999,2024020000]
[null,"2024080000111111","Freight outbound expenses",111111,"External",350370.99399999995,2024080000]
[null,"202409000088","R&D expenses",88,"Generco Ltd",3116017.1540000001,2024090000]
[null,"20240900001283","R&D expenses","1283","Generco Ventures Ltd",0,2024090000]
[null,"20240900001924","R&D expenses","1924","Generco Infrastructure Ltd",673.34299999999985,2024090000]
[null,"20240900002185","R&D expenses","2185","Generco Green Projects GmbH",192017.14499999996,2024090000]
[null,"20240900002240","R&D expenses","2240","Greeny Germany GmbH",375290.46599999996,2024090000]
[null,"202409000017000","R&D expenses",17000,"Generco Risk Management Ltd",4920,2024090000]
[null,"2024090000111111","R&D expenses",111111,"External",9783.7069999999985,2024090000]
[null,"2041000000111111","Wages and salaries",111111,"External",3982699.5329999998,2041000000]
[null,"2042000000111101","Social security payments",111101,"Not assigned",1420796.8209999998,2042000000]
[null,"2042000000111101","Pension contributions",111101,"Not assigned",288891.82199999999,2042000000]
[null,"2045000000111101","Severance indemnity contribution",111101,"Not assigned",143500,2045000000]
[null,"2051210000111101","D&A",111101,"Not assigned",1875768.159,2051210000]
[null,"2051260000111101","D&A",111101,"Not assigned",12593.355,2051260000]
[null,"20604410001118","Other operative currency differences","1118","Gener Green LLC",0,2060441000]
[null,"2060441000111111","Other operative currency differences",111111,"External",-1252.8369999999998,2060441000]
[null,"20690100001","Corporate recharges","1","Greeny Ltd",-1418521.358,2069010000]
[null,"206901000019","Corporate recharges",19,"Generco Cosmetics Ltd",-622966.38600000006,2069010000]
[null,"20690100001076","Corporate recharges","1076","Generco Trading Ltd",0,2069010000]
[null,"20690100001086","Corporate recharges","1086","G&Resources Ltd",0,2069010000]
[null,"20690100001009","Corporate recharges",1009,"Green Ventures Ltd",0,2069010000]
[null,"20690100001007","Corporate recharges",1007,"Generco Sunshine JSC",0,2069010000]
[null,"20690100001008","Corporate recharges",1008,"Greenco Ltd",0,2069010000]
[null,"20690100001240","Corporate recharges",1240,"Generco UK ",0,2069010000]
[null,"20690100001006","Corporate recharges",1006,"Generco Mining GmbH",0,2069010000]
[null,"20690100001007","Corporate recharges",1007,"Generco Semiconductors Ltd",0,2069010000]
[null,"206901000047037","Corporate recharges","47037","G&CR Global Ltd",-1948832.1429999999,2069010000]
[null,"2069010000111111","Corporate recharges",111111,"External",-902857.84299999999,2069010000]
[null,"2069020000111111","Reimbursements+compensation for damages",111111,"External",-61499.999999999993,2069020000]
[null,"2069980000105","Other income",105,"Generco Healthcare Ltd",-30913.425999999996,2069980000]
[null,"2069980000111111","Other income",111111,"External",-15872.001999999999,2069980000]
[null,"2070400000111111","Marketing expenses",111111,"External",57.317999999999998,2070400000]
[null,"2070500000111111","Software&IT",111111,"External",19198.66,2070500000]
[null,"2070600000105","Leasings",105,"Generco Healthcare Ltd",-1423120,2070600000]
[null,"2070600000111111","Leasings",111111,"External",-172933.44899999999,2070600000]
[null,"2070900000105","Service expenses",105,"Generco Healthcare Ltd",473575.46100000001,2070900000]
[null,"2070900000111111","Service expenses",111111,"External",1481408.47,2070900000]
[null,"2071000000111111","Charges and contributions",111111,"External",40048.799999999996,2071000000]
[null,"207110000088","Insurance expenses",88,"Generco Ltd",584.66,2071100000]
[null,"2071100000111111","Insurance expenses",111111,"External",64039.82699999999,2071100000]
[null,"2071209100111111","Repairs/Maintenance costs",111111,"External",1352.9999999999998,2071209100]
[null,"2071209200111111","Travel expenses",111111,"External",2514431.8869999996,2071209200]
[null,"2071209400111111","Utility expenses",111111,"External",4194.2999999999993,2071209400]
[null,"2071209500111111","Legal expenses",111111,"External",106525.708,2071209500]
[null,"2071980000111101","Misc costs",111101,"Not assigned",109811.284,2071980000]
[null,"2079022000111111","Consulting fees",111111,"External",61111.483999999997,2079022000]
[null,"20790700001924","Misc extraordinary expenses","1924","Generco Infrastructure Ltd",0,2079070000]
[null,"2079070000105","Misc extraordinary expenses",105,"Generco Healthcare Ltd",1684415.2999999998,2079070000]
[null,"2079070000111111","Misc extraordinary expenses",111111,"External",575626.2649999999,2079070000]
[null,"20790800001086","Difference from eliminations","1086","G&Resources Ltd",0,2079080000]
[null,"20790800001007","Difference from eliminations",1007,"Generco Semiconductors Ltd",0,2079080000]
[null,"20822800001086","Interest income","1086","G&Resources Ltd",0,2082280000]
[null,"20822800001009","Interest income",1009,"Green Ventures Ltd",0,2082280000]
[null,"20822800001007","Interest income",1007,"Generco Sunshine JSC",0,2082280000]
[null,"20822800001008","Interest income",1008,"Greenco Ltd",0,2082280000]
[null,"20822800001240","Interest income",1240,"Generco UK ",0,2082280000]
[null,"20822800001006","Interest income",1006,"Generco Mining GmbH",0,2082280000]
[null,"2082280000111111","Interest income",111111,"External",-73809.511999999988,2082280000]
[null,"2082208200111101","Non-recurring costs",111101,"Not assigned",7173.195999999999,2082208200]
[null,"208221400088","Interest expenses",88,"Generco Ltd",2324465.8859999999,2082214000]
[null,"20822140001007","Interest expenses",1007,"Generco Semiconductors Ltd",0,2082214000]
[null,"2082214000111111","Interest expenses",111111,"External",51.454999999999998,2082214000]
[null,"2082110000111101","Impairment of participation",111101,"Not assigned",0,2082110000]
[null,"2091200000111101","Current taxes",111101,"Not assigned",2558.1950000000002,2091200000]
[null,"2091200001111101","Regional taxes",111101,"Not assigned",522710.353,2091200001]
[null,"2092200000111101","Deferred taxes",111101,"Not assigned",-160303.52199999997,2092200000]
[null,"2111111997111101","Offset segments (tech.)",111101,"Not assigned",0,2111111997]
[null,"2111111999111101","Net income/(loss)",111101,"Not assigned",{"$f":"-1479290.476+700000","v":-779290.47600000002},2111111999]

{"sheet":"2. Building a P&L -->","index":6,"n_rows":12,"n_cols":2,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"2. Building a P&L -->"]

{"sheet":"2.1 Database","index":7,"n_rows":108,"n_cols":11,"rows_kept":108,"cut":false,"hidden":false,"merged":[]}
[null,"Database"]
[]
[null,"Code","P&L account","Partner company","Name of Partner company","FY11","FY12","FY13",null,"Mapping"]
[null,"2001110000111111",{"$f":"+VLOOKUP($B4,'1.1 FY2011'!$B$5:$E$61,2,FALSE)","v":"Core business revenues"},{"$f":"+VLOOKUP($B4,'1.1 FY2011'!$B$5:$E$61,3,FALSE)","v":111111},{"$f":"+VLOOKUP($B4,'1.1 FY2011'!$B$5:$E$61,4,FALSE)","v":"External"},{"$f":"-SUMIF('1.1 FY2011'!$B:$B,'2.1 Database'!B4,'1.1 FY2011'!$F:$F)","v":14500341},{"$f":"-SUMIF('1.2 FY2012'!$B:$B,'2.1 Database'!B4,'1.2 FY2012'!$F:$F)","v":15792898.75},{"$f":"-SUMIF('1.3 FY2013'!$B:$B,'2.1 Database'!B4,'1.3 FY2013'!$F:$F)","v":14431341},null,"Net Sales",{"$f":"+COUNTIF('2.2 P&L statement'!$B$4:$B$24,'2.1 Database'!J4)","v":1}]
[null,"2001190000111111",{"$f":"+VLOOKUP($B5,'1.1 FY2011'!$B$5:$E$61,2,FALSE)","v":"Other revenues"},{"$f":"+VLOOKUP($B5,'1.1 FY2011'!$B$5:$E$61,3,FALSE)","v":111111},{"$f":"+VLOOKUP($B5,'1.1 FY2011'!$B$5:$E$61,4,FALSE)","v":"External"},{"$f":"-SUMIF('1.1 FY2011'!$B:$B,'2.1 Database'!B5,'1.1 FY2011'!$F:$F)","v":4794856.1919999998},{"$f":"-SUMIF('1.2 FY2012'!$B:$B,'2.1 Database'!B5,'1.2 FY2012'!$F:$F)","v":6960217.6449999996},{"$f":"-SUMIF('1.3 FY2013'!$B:$B,'2.1 Database'!B5,'1.3 FY2013'!$F:$F)","v":6373617.5140000004},null,"Other revenues",{"$f":"+COUNTIF('2.2 P&L statement'!$B$4:$B$24,'2.1 Database'!J5)","v":1}]
[null,"20200000001009",{"$f":"+VLOOKUP($B6,'1.1 FY2011'!$B$5:$E$61,2,FALSE)","v":"Capitalized costs"},{"$f":"+VLOOKUP($B6,'1.1 FY2011'!$B$5:$E$61,3,FALSE)","v":1009},{"$f":"+VLOOKUP($B6,'1.1 FY2011'!$B$5:$E$61,4,FALSE)","v":"Green Ventures Ltd"},{"$f":"-SUMIF('1.1 FY2011'!$B:$B,'2.1 Database'!B6,'1.1 FY2011'!$F:$F)","v":154890.4},{"$f":"-SUMIF('1.2 FY2012'!$B:$B,'2.1 Database'!B6,'1.2 FY2012'!$F:$F)","v":0},{"$f":"-SUMIF('1.3 FY2013'!$B:$B,'2.1 Database'!B6,'1.3 FY2013'!$F:$F)","v":0},null,"Capitalized costs",{"$f":"+COUNTIF('2.2 P&L statement'!$B$4:$B$24,'2.1 Database'!J6)","v":1}]
[null,"20200000001007",{"$f":"+VLOOKUP($B7,'1.1 FY2011'!$B$5:$E$61,2,FALSE)","v":"Capitalized costs"},{"$f":"+VLOOKUP($B7,'1.1 FY2011'!$B$5:$E$61,3,FALSE)","v":1007},{"$f":"+VLOOKUP($B7,'1.1 FY2011'!$B$5:$E$61,4,FALSE)","v":"Generco Sunshine JSC"},{"$f":"-SUMIF('1.1 FY2011'!$B:$B,'2.1 Database'!B7,'1.1 FY2011'!$F:$F)","v":1180894.0520000001},{"$f":"-SUMIF('1.2 FY2012'!$B:$B,'2.1 Database'!B7,'1.2 FY2012'!$F:$F)","v":89234.880000000005},{"$f":"-SUMIF('1.3 FY2013'!$B:$B,'2.1 Database'!B7,'1.3 FY2013'!$F:$F)","v":0},null,"Capitalized costs",{"$f":"+COUNTIF('2.2 P&L statement'!$B$4:$B$24,'2.1 Database'!J7)","v":1}]
[null,"20200000001008",{"$f":"+VLOOKUP($B8,'1.1 FY2011'!$B$5:$E$61,2,FALSE)","v":"Capitalized costs"},{"$f":"+VLOOKUP($B8,'1.1 FY2011'!$B$5:$E$61,3,FALSE)","v":1008},{"$f":"+VLOOKUP($B8,'1.1 FY2011'!$B$5:$E$61,4,FALSE)","v":"Greenco Ltd"},{"$f":"-SUMIF('1.1 FY2011'!$B:$B,'2.1 Database'!B8,'1.1 FY2011'!$F:$F)","v":793079.51199999999},{"$f":"-SUMIF('1.2 FY2012'!$B:$B,'2.1 Database'!B8,'1.2 FY2012'!$F:$F)","v":26173},{"$f":"-SUMIF('1.3 FY2013'!$B:$B,'2.1 Database'!B8,'1.3 FY2013'!$F:$F)","v":0},null,"Capitalized costs",{"$f":"+COUNTIF('2.2 P&L statement'!$B$4:$B$24,'2.1 Database'!J8)","v":1}]
[null,"2020000000111101",{"$f":"+VLOOKUP($B9,'1.1 FY2011'!$B$5:$E$61,2,FALSE)","v":"Capitalized costs"},{"$f":"+VLOOKUP($B9,'1.1 FY2011'!$B$5:$E$61,3,FALSE)","v":111101},{"$f":"+VLOOKUP($B9,'1.1 FY2011'!$B$5:$E$61,4,FALSE)","v":"Not assigned"},{"$f":"-SUMIF('1.1 FY2011'!$B:$B,'2.1 Database'!B9,'1.1 FY2011'!$F:$F)","v":2277197.6},{"$f":"-SUMIF('1.2 FY2012'!$B:$B,'2.1 Database'!B9,'1.2 FY2012'!$F:$F)","v":209401.92},{"$f":"-SUMIF('1.3 FY2013'!$B:$B,'2.1 Database'!B9,'1.3 FY2013'!$F:$F)","v":0},null,"Capitalized costs",{"$f":"+COUNTIF('2.2 P&L statement'!$B$4:$B$24,'2.1 Database'!J9)","v":1}]
[null,"2021900000111111",{"$f":"+VLOOKUP($B10,'1.1 FY2011'!$B$5:$E$61,2,FALSE)","v":"Direct costs"},{"$f":"+VLOOKUP($B10,'1.1 FY2011'!$B$5:$E$61,3,FALSE)","v":111111},{"$f":"+VLOOKUP($B10,'1.1 FY2011'!$B$5:$E$61,4,FALSE)","v":"External"},{"$f":"-SUMIF('1.1 FY2011'!$B:$B,'2.1 Database'!B10,'1.1 FY2011'!$F:$F)","v":-4428911.7640000004},{"$f":"-SUMIF('1.2 FY2012'!$B:$B,'2.1 Database'!B10,'1.2 FY2012'!$F:$F)","v":-5463188.8250000002},{"$f":"-SUMIF('1.3 FY2013'!$B:$B,'2.1 Database'!B10,'1.3 FY2013'!$F:$F)","v":-5674152.0669999998},null,"Direct costs",{"$f":"+COUNTIF('2.2 P&L statement'!$B$4:$B$24,'2.1 Database'!J10)","v":1}]
[null,"2024080000111111",{"$f":"+VLOOKUP($B11,'1.1 FY2011'!$B$5:$E$61,2,FALSE)","v":"Freight outbound expenses"},{"$f":"+VLOOKUP($B11,'1.1 FY2011'!$B$5:$E$61,3,FALSE)","v":111111},{"$f":"+VLOOKUP($B11,'1.1 FY2011'!$B$5:$E$61,4,FALSE)","v":"External"},{"$f":"-SUMIF('1.1 FY2011'!$B:$B,'2.1 Database'!B11,'1.1 FY2011'!$F:$F)","v":-16977.628000000001},{"$f":"-SUMIF('1.2 FY2012'!$B:$B,'2.1 Database'!B11,'1.2 FY2012'!$F:$F)","v":-343675},{"$f":"-SUMIF('1.3 FY2013'!$B:$B,'2.1 Database'!B11,'1.3 FY2013'!$F:$F)","v":-350370.99399999995},null,"Other operating expenses",{"$f":"+COUNTIF('2.2 P&L statement'!$B$4:$B$24,'2.1 Database'!J11)","v":1}]
[null,"202409000088",{"$f":"+VLOOKUP($B12,'1.1 FY2011'!$B$5:$E$61,2,FALSE)","v":"R&D expenses"},{"$f":"+VLOOKUP($B12,'1.1 FY2011'!$B$5:$E$61,3,FALSE)","v":88},{"$f":"+VLOOKUP($B12,'1.1 FY2011'!$B$5:$E$61,4,FALSE)","v":"Generco Ltd"},{"$f":"-SUMIF('1.1 FY2011'!$B:$B,'2.1 Database'!B12,'1.1 FY2011'!$F:$F)","v":-2245437.54},{"$f":"-SUMIF('1.2 FY2012'!$B:$B,'2.1 Database'!B12,'1.2 FY2012'!$F:$F)","v":-1980162.23},{"$f":"-SUMIF('1.3 FY2013'!$B:$B,'2.1 Database'!B12,'1.3 FY2013'!$F:$F)","v":-3116017.1540000001},null,"Other operating expenses",{"$f":"+COUNTIF('2.2 P&L statement'!$B$4:$B$24,'2.1 Database'!J12)","v":1}]
[null,"2024090000111111",{"$f":"+VLOOKUP($B13,'1.1 FY2011'!$B$5:$E$61,2,FALSE)","v":"R&D expenses"},{"$f":"+VLOOKUP($B13,'1.1 FY2011'!$B$5:$E$61,3,FALSE)","v":111111},{"$f":"+VLOOKUP($B13,'1.1 FY2011'!$B$5:$E$61,4,FALSE)","v":"External"},{"$f":"-SUMIF('1.1 FY2011'!$B:$B,'2.1 Database'!B13,'1.1 FY2011'!$F:$F)","v":-16605.634000000002},{"$f":"-SUMIF('1.2 FY2012'!$B:$B,'2.1 Database'!B13,'1.2 FY2012'!$F:$F)","v":-27148.625},{"$f":"-SUMIF('1.3 FY2013'!$B:$B,'2.1 Database'!B13,'1.3 FY2013'!$F:$F)","v":-9783.7069999999985},null,"Other operating expenses",{"$f":"+COUNTIF('2.2 P&L statement'!$B$4:$B$24,'2.1 Database'!J13)","v":1}]
[null,"2041000000111111",{"$f":"+VLOOKUP($B14,'1.1 FY2011'!$B$5:$E$61,2,FALSE)","v":"Wages and salaries"},{"$f":"+VLOOKUP($B14,'1.1 FY2011'!$B$5:$E$61,3,FALSE)","v":111111},{"$f":"+VLOOKUP($B14,'1.1 FY2011'!$B$5:$E$61,4,FALSE)","v":"External"},{"$f":"-SUMIF('1.1 FY2011'!$B:$B,'2.1 Database'!B14,'1.1 FY2011'!$F:$F)","v":-4683394.0460000001},{"$f":"-SUMIF('1.2 FY2012'!$B:$B,'2.1 Database'!B14,'1.2 FY2012'!$F:$F)","v":-5507141.0549999997},{"$f":"-SUMIF('1.3 FY2013'!$B:$B,'2.1 Database'!B14,'1.3 FY2013'!$F:$F)","v":-3982699.5329999998},null,"Personnel expenses",{"$f":"+COUNTIF('2.2 P&L statement'!$B$4:$B$24,'2.1 Database'!J14)","v":1}]
[null,"2042000000111101",{"$f":"+VLOOKUP($B15,'1.1 FY2011'!$B$5:$E$61,2,FALSE)","v":"Pension contributions"},{"$f":"+VLOOKUP($B15,'1.1 FY2011'!$B$5:$E$61,3,FALSE)","v":111101},{"$f":"+VLOOKUP($B15,'1.1 FY2011'!$B$5:$E$61,4,FALSE)","v":"Not assigned"},{"$f":"-SUMIF('1.1 FY2011'!$B:$B,'2.1 Database'!B15,'1.1 FY2011'!$F:$F)","v":-1143051.5760000001},{"$f":"-SUMIF('1.2 FY2012'!$B:$B,'2.1 Database'!B15,'1.2 FY2012'!$F:$F)","v":-2057298.04},{"$f":"-SUMIF('1.3 FY2013'!$B:$B,'2.1 Database'!B15,'1.3 FY2013'!$F:$F)","v":-1709688.6429999997},null,"Personnel expenses",{"$f":"+COUNTIF('2.2 P&L statement'!$B$4:$B$24,'2.1 Database'!J15)","v":1}]
[null,"204200000088",{"$f":"+VLOOKUP($B16,'1.1 FY2011'!$B$5:$E$61,2,FALSE)","v":"Pension contributions"},{"$f":"+VLOOKUP($B16,'1.1 FY2011'!$B$5:$E$61,3,FALSE)","v":88},{"$f":"+VLOOKUP($B16,'1.1 FY2011'!$B$5:$E$61,4,FALSE)","v":"Generco Ltd"},{"$f":"-SUMIF('1.1 FY2011'!$B:$B,'2.1 Database'!B16,'1.1 FY2011'!$F:$F)","v":-239379.61800000002},{"$f":"-SUMIF('1.2 FY2012'!$B:$B,'2.1 Database'!B16,'1.2 FY2012'!$F:$F)","v":0},{"$f":"-SUMIF('1.3 FY2013'!$B:$B,'2.1 Database'!B16,'1.3 FY2013'!$F:$F)","v":0},null,"Personnel expenses",{"$f":"+COUNTIF('2.2 P&L statement'!$B$4:$B$24,'2.1 Database'!J16)","v":1}]
[null,"2045000000111101",{"$f":"+VLOOKUP($B17,'1.1 FY2011'!$B$5:$E$61,2,FALSE)","v":"Severance indemnity contribution"},{"$f":"+VLOOKUP($B17,'1.1 FY2011'!$B$5:$E$61,3,FALSE)","v":111101},{"$f":"+VLOOKUP($B17,'1.1 FY2011'!$B$5:$E$61,4,FALSE)","v":"Not assigned"},{"$f":"-SUMIF('1.1 FY2011'!$B:$B,'2.1 Database'!B17,'1.1 FY2011'!$F:$F)","v":-104913.8},{"$f":"-SUMIF('1.2 FY2012'!$B:$B,'2.1 Database'!B17,'1.2 FY2012'!$F:$F)","v":-500500},{"$f":"-SUMIF('1.3 FY2013'!$B:$B,'2.1 Database'!B17,'1.3 FY2013'!$F:$F)","v":-143500},null,"Personnel expenses",{"$f":"+COUNTIF('2.2 P&L statement'!$B$4:$B$24,'2.1 Database'!J17)","v":1}]
[null,"2051210000111101",{"$f":"+VLOOKUP($B18,'1.1 FY2011'!$B$5:$E$61,2,FALSE)","v":"D&A"},{"$f":"+VLOOKUP($B18,'1.1 FY2011'!$B$5:$E$61,3,FALSE)","v":111101},{"$f":"+VLOOKUP($B18,'1.1 FY2011'!$B$5:$E$61,4,FALSE)","v":"Not assigned"},{"$f":"-SUMIF('1.1 FY2011'!$B:$B,'2.1 Database'!B18,'1.1 FY2011'!$F:$F)","v":-2003262.2180000001},{"$f":"-SUMIF('1.2 FY2012'!$B:$B,'2.1 Database'!B18,'1.2 FY2012'!$F:$F)","v":-1897676.87},{"$f":"-SUMIF('1.3 FY2013'!$B:$B,'2.1 Database'!B18,'1.3 FY2013'!$F:$F)","v":-1875768.159},null,"D&A",{"$f":"+COUNTIF('2.2 P&L statement'!$B$4:$B$24,'2.1 Database'!J18)","v":1}]
[null,"2051260000111101",{"$f":"+VLOOKUP($B19,'1.1 FY2011'!$B$5:$E$61,2,FALSE)","v":"D&A"},{"$f":"+VLOOKUP($B19,'1.1 FY2011'!$B$5:$E$61,3,FALSE)","v":111101},{"$f":"+VLOOKUP($B19,'1.1 FY2011'!$B$5:$E$61,4,FALSE)","v":"Not assigned"},{"$f":"-SUMIF('1.1 FY2011'!$B:$B,'2.1 Database'!B19,'1.1 FY2011'!$F:$F)","v":-41981.296000000002},{"$f":"-SUMIF('1.2 FY2012'!$B:$B,'2.1 Database'!B19,'1.2 FY2012'!$F:$F)","v":-146328.94499999998},{"$f":"-SUMIF('1.3 FY2013'!$B:$B,'2.1 Database'!B19,'1.3 FY2013'!$F:$F)","v":-12593.355},null,"D&A",{"$f":"+COUNTIF('2.2 P&L statement'!$B$4:$B$24,'2.1 Database'!J19)","v":1}]
[null,"20690100001",{"$f":"+VLOOKUP($B20,'1.1 FY2011'!$B$5:$E$61,2,FALSE)","v":"Corporate recharges"},{"$f":"+VLOOKUP($B20,'1.1 FY2011'!$B$5:$E$61,3,FALSE)","v":"1"},{"$f":"+VLOOKUP($B20,'1.1 FY2011'!$B$5:$E$61,4,FALSE)","v":"Greeny Ltd"},{"$f":"-SUMIF('1.1 FY2011'!$B:$B,'2.1 Database'!B20,'1.1 FY2011'!$F:$F)","v":2156147.4},{"$f":"-SUMIF('1.2 FY2012'!$B:$B,'2.1 Database'!B20,'1.2 FY2012'!$F:$F)","v":1643711.145},{"$f":"-SUMIF('1.3 FY2013'!$B:$B,'2.1 Database'!B20,'1.3 FY2013'!$F:$F)","v":1418521.358},null,"Recharges",{"$f":"+COUNTIF('2.2 P&L statement'!$B$4:$B$24,'2.1 Database'!J20)","v":1}]
[null,"206901000014",{"$f":"+VLOOKUP($B21,'1.1 FY2011'!$B$5:$E$61,2,FALSE)","v":"Corporate recharges"},{"$f":"+VLOOKUP($B21,'1.1 FY2011'!$B$5:$E$61,3,FALSE)","v":14},{"$f":"+VLOOKUP($B21,'1.1 FY2011'!$B$5:$E$61,4,FALSE)","v":"Generco Cosmetics Ltd"},{"$f":"-SUMIF('1.1 FY2011'!$B:$B,'2.1 Database'!B21,'1.1 FY2011'!$F:$F)","v":291428.55199999997},{"$f":"-SUMIF('1.2 FY2012'!$B:$B,'2.1 Database'!B21,'1.2 FY2012'!$F:$F)","v":0},{"$f":"-SUMIF('1.3 FY2013'!$B:$B,'2.1 Database'!B21,'1.3 FY2013'!$F:$F)","v":0},null,"Recharges",{"$f":"+COUNTIF('2.2 P&L statement'!$B$4:$B$24,'2.1 Database'!J21)","v":1}]
[null,"20690100001037",{"$f":"+VLOOKUP($B22,'1.1 FY2011'!$B$5:$E$61,2,FALSE)","v":"Corporate recharges"},{"$f":"+VLOOKUP($B22,'1.1 FY2011'!$B$5:$E$61,3,FALSE)","v":1037},{"$f":"+VLOOKUP($B22,'1.1 FY2011'!$B$5:$E$61,4,FALSE)","v":"Generco Canada JSC"},{"$f":"-SUMIF('1.1 FY2011'!$B:$B,'2.1 Database'!B22,'1.1 FY2011'!$F:$F)","v":0},{"$f":"-SUMIF('1.2 FY2012'!$B:$B,'2.1 Database'!B22,'1.2 FY2012'!$F:$F)","v":0},{"$f":"-SUMIF('1.3 FY2013'!$B:$B,'2.1 Database'!B22,'1.3 FY2013'!$F:$F)","v":0},null,"Recharges",{"$f":"+COUNTIF('2.2 P&L statement'!$B$4:$B$24,'2.1 Database'!J22)","v":1}]
[null,"20690100001087",{"$f":"+VLOOKUP($B23,'1.1 FY2011'!$B$5:$E$61,2,FALSE)","v":"Corporate recharges"},{"$f":"+VLOOKUP($B23,'1.1 FY2011'!$B$5:$E$61,3,FALSE)","v":"1087"},{"$f":"+VLOOKUP($B23,'1.1 FY2011'!$B$5:$E$61,4,FALSE)","v":"Gener Beauty GmbH"},{"$f":"-SUMIF('1.1 FY2011'!$B:$B,'2.1 Database'!B23,'1.1 FY2011'!$F:$F)","v":33736.5},{"$f":"-SUMIF('1.2 FY2012'!$B:$B,'2.1 Database'!B23,'1.2 FY2012'!$F:$F)","v":0},{"$f":"-SUMIF('1.3 FY2013'!$B:$B,'2.1 Database'!B23,'1.3 FY2013'!$F:$F)","v":0},null,"Recharges",{"$f":"+COUNTIF('2.2 P&L statement'!$B$4:$B$24,'2.1 Database'!J23)","v":1}]
[null,"20690100001009",{"$f":"+VLOOKUP($B24,'1.1 FY2011'!$B$5:$E$61,2,FALSE)","v":"Corporate recharges"},{"$f":"+VLOOKUP($B24,'1.1 FY2011'!$B$5:$E$61,3,FALSE)","v":1009},{"$f":"+VLOOKUP($B24,'1.1 FY2011'!$B$5:$E$61,4,FALSE)","v":"Green Ventures Ltd"},{"$f":"-SUMIF('1.1 FY2011'!$B:$B,'2.1 Database'!B24,'1.1 FY2011'!$F:$F)","v":0},{"$f":"-SUMIF('1.2 FY2012'!$B:$B,'2.1 Database'!B24,'1.2 FY2012'!$F:$F)","v":0},{"$f":"-SUMIF('1.3 FY2013'!$B:$B,'2.1 Database'!B24,'1.3 FY2013'!$F:$F)","v":0},null,"Recharges",{"$f":"+COUNTIF('2.2 P&L statement'!$B$4:$B$24,'2.1 Database'!J24)","v":1}]
[null,"20690100001007",{"$f":"+VLOOKUP($B25,'1.1 FY2011'!$B$5:$E$61,2,FALSE)","v":"Corporate recharges"},{"$f":"+VLOOKUP($B25,'1.1 FY2011'!$B$5:$E$61,3,FALSE)","v":1007},{"$f":"+VLOOKUP($B25,'1.1 FY2011'!$B$5:$E$61,4,FALSE)","v":"Generco Sunshine JSC"},{"$f":"-SUMIF('1.1 FY2011'!$B:$B,'2.1 Database'!B25,'1.1 FY2011'!$F:$F)","v":0},{"$f":"-SUMIF('1.2 FY2012'!$B:$B,'2.1 Database'!B25,'1.2 FY2012'!$F:$F)","v":0},{"$f":"-SUMIF('1.3 FY2013'!$B:$B,'2.1 Database'!B25,'1.3 FY2013'!$F:$F)","v":0},null,"Recharges",{"$f":"+COUNTIF('2.2 P&L statement'!$B$4:$B$24,'2.1 Database'!J25)","v":1}]
[null,"20690100001008",{"$f":"+VLOOKUP($B26,'1.1 FY2011'!$B$5:$E$61,2,FALSE)","v":"Corporate recharges"},{"$f":"+VLOOKUP($B26,'1.1 FY2011'!$B$5:$E$61,3,FALSE)","v":1008},{"$f":"+VLOOKUP($B26,'1.1 FY2011'!$B$5:$E$61,4,FALSE)","v":"Greenco Ltd"},{"$f":"-SUMIF('1.1 FY2011'!$B:$B,'2.1 Database'!B26,'1.1 FY2011'!$F:$F)","v":0},{"$f":"-SUMIF('1.2 FY2012'!$B:$B,'2.1 Database'!B26,'1.2 FY2012'!$F:$F)","v":0},{"$f":"-SUMIF('1.3 FY2013'!$B:$B,'2.1 Database'!B26,'1.3 FY2013'!$F:$F)","v":0},null,"Recharges",{"$f":"+COUNTIF('2.2 P&L statement'!$B$4:$B$24,'2.1 Database'!J26)","v":1}]
[null,"20690100001240",{"$f":"+VLOOKUP($B27,'1.1 FY2011'!$B$5:$E$61,2,FALSE)","v":"Corporate recharges"},{"$f":"+VLOOKUP($B27,'1.1 FY2011'!$B$5:$E$61,3,FALSE)","v":1240},{"$f":"+VLOOKUP($B27,'1.1 FY2011'!$B$5:$E$61,4,FALSE)","v":"Generco UK "},{"$f":"-SUMIF('1.1 FY2011'!$B:$B,'2.1 Database'!B27,'1.1 FY2011'!$F:$F)","v":199600.4},{"$f":"-SUMIF('1.2 FY2012'!$B:$B,'2.1 Database'!B27,'1.2 FY2012'!$F:$F)","v":10461.36},{"$f":"-SUMIF('1.3 FY2013'!$B:$B,'2.1 Database'!B27,'1.3 FY2013'!$F:$F)","v":0},null,"Recharges",{"$f":"+COUNTIF('2.2 P&L statement'!$B$4:$B$24,'2.1 Database'!J27)","v":1}]
[null,"2069010000111111",{"$f":"+VLOOKUP($B28,'1.1 FY2011'!$B$5:$E$61,2,FALSE)","v":"Corporate recharges"},{"$f":"+VLOOKUP($B28,'1.1 FY2011'!$B$5:$E$61,3,FALSE)","v":111111},{"$f":"+VLOOKUP($B28,'1.1 FY2011'!$B$5:$E$61,4,FALSE)","v":"External"},{"$f":"-SUMIF('1.1 FY2011'!$B:$B,'2.1 Database'!B28,'1.1 FY2011'!$F:$F)","v":539141.4},{"$f":"-SUMIF('1.2 FY2012'!$B:$B,'2.1 Database'!B28,'1.2 FY2012'!$F:$F)","v":6785.94},{"$f":"-SUMIF('1.3 FY2013'!$B:$B,'2.1 Database'!B28,'1.3 FY2013'!$F:$F)","v":902857.84299999999},null,"Recharges",{"$f":"+COUNTIF('2.2 P&L statement'!$B$4:$B$24,'2.1 Database'!J28)","v":1}]
[null,"2069980000111111",{"$f":"+VLOOKUP($B29,'1.1 FY2011'!$B$5:$E$61,2,FALSE)","v":"Other income"},{"$f":"+VLOOKUP($B29,'1.1 FY2011'!$B$5:$E$61,3,FALSE)","v":111111},{"$f":"+VLOOKUP($B29,'1.1 FY2011'!$B$5:$E$61,4,FALSE)","v":"External"},{"$f":"-SUMIF('1.1 FY2011'!$B:$B,'2.1 Database'!B29,'1.1 FY2011'!$F:$F)","v":57.221999999999994},{"$f":"-SUMIF('1.2 FY2012'!$B:$B,'2.1 Database'!B29,'1.2 FY2012'!$F:$F)","v":-9793.84},{"$f":"-SUMIF('1.3 FY2013'!$B:$B,'2.1 Database'!B29,'1.3 FY2013'!$F:$F)","v":15872.001999999999},null,"Other income",{"$f":"+COUNTIF('2.2 P&L statement'!$B$4:$B$24,'2.1 Database'!J29)","v":1}]
[null,"2070400000111111",{"$f":"+VLOOKUP($B30,'1.1 FY2011'!$B$5:$E$61,2,FALSE)","v":"Marketing expenses"},{"$f":"+VLOOKUP($B30,'1.1 FY2011'!$B$5:$E$61,3,FALSE)","v":111111},{"$f":"+VLOOKUP($B30,'1.1 FY2011'!$B$5:$E$61,4,FALSE)","v":"External"},{"$f":"-SUMIF('1.1 FY2011'!$B:$B,'2.1 Database'!B30,'1.1 FY2011'!$F:$F)","v":-22314.879999999997},{"$f":"-SUMIF('1.2 FY2012'!$B:$B,'2.1 Database'!B30,'1.2 FY2012'!$F:$F)","v":-65947.7},{"$f":"-SUMIF('1.3 FY2013'!$B:$B,'2.1 Database'!B30,'1.3 FY2013'!$F:$F)","v":-57.317999999999998},null,"Other operating expenses",{"$f":"+COUNTIF('2.2 P&L statement'!$B$4:$B$24,'2.1 Database'!J30)","v":1}]
[null,"207050000088",{"$f":"+VLOOKUP($B31,'1.1 FY2011'!$B$5:$E$61,2,FALSE)","v":"Software&IT"},{"$f":"+VLOOKUP($B31,'1.1 FY2011'!$B$5:$E$61,3,FALSE)","v":88},{"$f":"+VLOOKUP($B31,'1.1 FY2011'!$B$5:$E$61,4,FALSE)","v":"Generco Ltd"},{"$f":"-SUMIF('1.1 FY2011'!$B:$B,'2.1 Database'!B31,'1.1 FY2011'!$F:$F)","v":-204000},{"$f":"-SUMIF('1.2 FY2012'!$B:$B,'2.1 Database'!B31,'1.2 FY2012'!$F:$F)","v":0},{"$f":"-SUMIF('1.3 FY2013'!$B:$B,'2.1 Database'!B31,'1.3 FY2013'!$F:$F)","v":0},null,"Other operating expenses",{"$f":"+COUNTIF('2.2 P&L statement'!$B$4:$B$24,'2.1 Database'!J31)","v":1}]
[null,"2070500000111111",{"$f":"+VLOOKUP($B32,'1.1 FY2011'!$B$5:$E$61,2,FALSE)","v":"Software&IT"},{"$f":"+VLOOKUP($B32,'1.1 FY2011'!$B$5:$E$61,3,FALSE)","v":111111},{"$f":"+VLOOKUP($B32,'1.1 FY2011'!$B$5:$E$61,4,FALSE)","v":"External"},{"$f":"-SUMIF('1.1 FY2011'!$B:$B,'2.1 Database'!B32,'1.1 FY2011'!$F:$F)","v":-138.41399999999999},{"$f":"-SUMIF('1.2 FY2012'!$B:$B,'2.1 Database'!B32,'1.2 FY2012'!$F:$F)","v":-5138.91},{"$f":"-SUMIF('1.3 FY2013'!$B:$B,'2.1 Database'!B32,'1.3 FY2013'!$F:$F)","v":-19198.66},null,"Other operating expenses",{"$f":"+COUNTIF('2.2 P&L statement'!$B$4:$B$24,'2.1 Database'!J32)","v":1}]
[null,"2070600000111111",{"$f":"+VLOOKUP($B33,'1.1 FY2011'!$B$5:$E$61,2,FALSE)","v":"Leasings"},{"$f":"+VLOOKUP($B33,'1.1 FY2011'!$B$5:$E$61,3,FALSE)","v":111111},{"$f":"+VLOOKUP($B33,'1.1 FY2011'!$B$5:$E$61,4,FALSE)","v":"External"},{"$f":"-SUMIF('1.1 FY2011'!$B:$B,'2.1 Database'!B33,'1.1 FY2011'!$F:$F)","v":-1127445.872},{"$f":"-SUMIF('1.2 FY2012'!$B:$B,'2.1 Database'!B33,'1.2 FY2012'!$F:$F)","v":-1055381.4750000001},{"$f":"-SUMIF('1.3 FY2013'!$B:$B,'2.1 Database'!B33,'1.3 FY2013'!$F:$F)","v":172933.44899999999},null,"Leasing",{"$f":"+COUNTIF('2.2 P&L statement'!$B$4:$B$24,'2.1 Database'!J33)","v":1}]
[null,"207090000043",{"$f":"+VLOOKUP($B34,'1.1 FY2011'!$B$5:$E$61,2,FALSE)","v":"Service expenses"},{"$f":"+VLOOKUP($B34,'1.1 FY2011'!$B$5:$E$61,3,FALSE)","v":"43"},{"$f":"+VLOOKUP($B34,'1.1 FY2011'!$B$5:$E$61,4,FALSE)","v":"Greeny France SL"},{"$f":"-SUMIF('1.1 FY2011'!$B:$B,'2.1 Database'!B34,'1.1 FY2011'!$F:$F)","v":-133722},{"$f":"-SUMIF('1.2 FY2012'!$B:$B,'2.1 Database'!B34,'1.2 FY2012'!$F:$F)","v":0},{"$f":"-SUMIF('1.3 FY2013'!$B:$B,'2.1 Database'!B34,'1.3 FY2013'!$F:$F)","v":0},null,"Services",{"$f":"+COUNTIF('2.2 P&L statement'!$B$4:$B$24,'2.1 Database'!J34)","v":1}]
[null,"20709000002240",{"$f":"+VLOOKUP($B35,'1.1 FY2011'!$B$5:$E$61,2,FALSE)","v":"Service expenses"},{"$f":"+VLOOKUP($B35,'1.1 FY2011'!$B$5:$E$61,3,FALSE)","v":"2240"},{"$f":"+VLOOKUP($B35,'1.1 FY2011'!$B$5:$E$61,4,FALSE)","v":"Greeny Germany GmbH"},{"$f":"-SUMIF('1.1 FY2011'!$B:$B,'2.1 Database'!B35,'1.1 FY2011'!$F:$F)","v":-328061.886},{"$f":"-SUMIF('1.2 FY2012'!$B:$B,'2.1 Database'!B35,'1.2 FY2012'!$F:$F)","v":-430845.34499999997},{"$f":"-SUMIF('1.3 FY2013'!$B:$B,'2.1 Database'!B35,'1.3 FY2013'!$F:$F)","v":0},null,"Services",{"$f":"+COUNTIF('2.2 P&L statement'!$B$4:$B$24,'2.1 Database'!J35)","v":1}]
[null,"2070900000111111",{"$f":"+VLOOKUP($B36,'1.1 FY2011'!$B$5:$E$61,2,FALSE)","v":"Service expenses"},{"$f":"+VLOOKUP($B36,'1.1 FY2011'!$B$5:$E$61,3,FALSE)","v":111111},{"$f":"+VLOOKUP($B36,'1.1 FY2011'!$B$5:$E$61,4,FALSE)","v":"External"},{"$f":"-SUMIF('1.1 FY2011'!$B:$B,'2.1 Database'!B36,'1.1 FY2011'!$F:$F)","v":-2081304.3219999997},{"$f":"-SUMIF('1.2 FY2012'!$B:$B,'2.1 Database'!B36,'1.2 FY2012'!$F:$F)","v":-1130021},{"$f":"-SUMIF('1.3 FY2013'!$B:$B,'2.1 Database'!B36,'1.3 FY2013'!$F:$F)","v":-1481408.47},null,"Services",{"$f":"+COUNTIF('2.2 P&L statement'!$B$4:$B$24,'2.1 Database'!J36)","v":1}]
[null,"2071000000111111",{"$f":"+VLOOKUP($B37,'1.1 FY2011'!$B$5:$E$61,2,FALSE)","v":"Charges and contributions"},{"$f":"+VLOOKUP($B37,'1.1 FY2011'!$B$5:$E$61,3,FALSE)","v":111111},{"$f":"+VLOOKUP($B37,'1.1 FY2011'!$B$5:$E$61,4,FALSE)","v":"External"},{"$f":"-SUMIF('1.1 FY2011'!$B:$B,'2.1 Database'!B37,'1.1 FY2011'!$F:$F)","v":-33410.031999999999},{"$f":"-SUMIF('1.2 FY2012'!$B:$B,'2.1 Database'!B37,'1.2 FY2012'!$F:$F)","v":-7293.5450000000001},{"$f":"-SUMIF('1.3 FY2013'!$B:$B,'2.1 Database'!B37,'1.3 FY2013'!$F:$F)","v":-40048.799999999996},null,"Other operating expenses",{"$f":"+COUNTIF('2.2 P&L statement'!$B$4:$B$24,'2.1 Database'!J37)","v":1}]
[null,"2071100000111111",{"$f":"+VLOOKUP($B38,'1.1 FY2011'!$B$5:$E$61,2,FALSE)","v":"Insurance expenses"},{"$f":"+VLOOKUP($B38,'1.1 FY2011'!$B$5:$E$61,3,FALSE)","v":111111},{"$f":"+VLOOKUP($B38,'1.1 FY2011'!$B$5:$E$61,4,FALSE)","v":"External"},{"$f":"-SUMIF('1.1 FY2011'!$B:$B,'2.1 Database'!B38,'1.1 FY2011'!$F:$F)","v":-213090.85199999998},{"$f":"-SUMIF('1.2 FY2012'!$B:$B,'2.1 Database'!B38,'1.2 FY2012'!$F:$F)","v":-48468.665000000001},{"$f":"-SUMIF('1.3 FY2013'!$B:$B,'2.1 Database'!B38,'1.3 FY2013'!$F:$F)","v":-64039.82699999999},null,"Other operating expenses",{"$f":"+COUNTIF('2.2 P&L statement'!$B$4:$B$24,'2.1 Database'!J38)","v":1}]
[null,"2071209200111111",{"$f":"+VLOOKUP($B39,'1.1 FY2011'!$B$5:$E$61,2,FALSE)","v":"Travel expenses"},{"$f":"+VLOOKUP($B39,'1.1 FY2011'!$B$5:$E$61,3,FALSE)","v":111111},{"$f":"+VLOOKUP($B39,'1.1 FY2011'!$B$5:$E$61,4,FALSE)","v":"External"},{"$f":"-SUMIF('1.1 FY2011'!$B:$B,'2.1 Database'!B39,'1.1 FY2011'!$F:$F)","v":-1813525.004},{"$f":"-SUMIF('1.2 FY2012'!$B:$B,'2.1 Database'!B39,'1.2 FY2012'!$F:$F)","v":-2393259.19},{"$f":"-SUMIF('1.3 FY2013'!$B:$B,'2.1 Database'!B39,'1.3 FY2013'!$F:$F)","v":-2514431.8869999996},null,"Travel costs",{"$f":"+COUNTIF('2.2 P&L statement'!$B$4:$B$24,'2.1 Database'!J39)","v":1}]
[null,"2071209400111111",{"$f":"+VLOOKUP($B40,'1.1 FY2011'!$B$5:$E$61,2,FALSE)","v":"Utility expenses"},{"$f":"+VLOOKUP($B40,'1.1 FY2011'!$B$5:$E$61,3,FALSE)","v":111111},{"$f":"+VLOOKUP($B40,'1.1 FY2011'!$B$5:$E$61,4,FALSE)","v":"External"},{"$f":"-SUMIF('1.1 FY2011'!$B:$B,'2.1 Database'!B40,'1.1 FY2011'!$F:$F)","v":-5552.2},{"$f":"-SUMIF('1.2 FY2012'!$B:$B,'2.1 Database'!B40,'1.2 FY2012'!$F:$F)","v":-23069.654999999999},{"$f":"-SUMIF('1.3 FY2013'!$B:$B,'2.1 Database'!B40,'1.3 FY2013'!$F:$F)","v":-4194.2999999999993},null,"Other operating expenses",{"$f":"+COUNTIF('2.2 P&L statement'!$B$4:$B$24,'2.1 Database'!J40)","v":1}]
[null,"2071209500111111",{"$f":"+VLOOKUP($B41,'1.1 FY2011'!$B$5:$E$61,2,FALSE)","v":"Legal expenses"},{"$f":"+VLOOKUP($B41,'1.1 FY2011'!$B$5:$E$61,3,FALSE)","v":111111},{"$f":"+VLOOKUP($B41,'1.1 FY2011'!$B$5:$E$61,4,FALSE)","v":"External"},{"$f":"-SUMIF('1.1 FY2011'!$B:$B,'2.1 Database'!B41,'1.1 FY2011'!$F:$F)","v":-43868.975999999995},{"$f":"-SUMIF('1.2 FY2012'!$B:$B,'2.1 Database'!B41,'1.2 FY2012'!$F:$F)","v":-208366.935},{"$f":"-SUMIF('1.3 FY2013'!$B:$B,'2.1 Database'!B41,'1.3 FY2013'!$F:$F)","v":-106525.708},null,"Other operating expenses",{"$f":"+COUNTIF('2.2 P&L statement'!$B$4:$B$24,'2.1 Database'!J41)","v":1}]
[null,"2071980000111101",{"$f":"+VLOOKUP($B42,'1.1 FY2011'!$B$5:$E$61,2,FALSE)","v":"Misc costs"},{"$f":"+VLOOKUP($B42,'1.1 FY2011'!$B$5:$E$61,3,FALSE)","v":111101},{"$f":"+VLOOKUP($B42,'1.1 FY2011'!$B$5:$E$61,4,FALSE)","v":"Not assigned"},{"$f":"-SUMIF('1.1 FY2011'!$B:$B,'2.1 Database'!B42,'1.1 FY2011'!$F:$F)","v":-10934.671999999999},{"$f":"-SUMIF('1.2 FY2012'!$B:$B,'2.1 Database'!B42,'1.2 FY2012'!$F:$F)","v":-20323.309999999998},{"$f":"-SUMIF('1.3 FY2013'!$B:$B,'2.1 Database'!B42,'1.3 FY2013'!$F:$F)","v":-109811.284},null,"Other operating expenses",{"$f":"+COUNTIF('2.2 P&L statement'!$B$4:$B$24,'2.1 Database'!J42)","v":1}]
[null,"2079022000111111",{"$f":"+VLOOKUP($B43,'1.1 FY2011'!$B$5:$E$61,2,FALSE)","v":"Consulting fees"},{"$f":"+VLOOKUP($B43,'1.1 FY2011'!$B$5:$E$61,3,FALSE)","v":111111},{"$f":"+VLOOKUP($B43,'1.1 FY2011'!$B$5:$E$61,4,FALSE)","v":"External"},{"$f":"-SUMIF('1.1 FY2011'!$B:$B,'2.1 Database'!B43,'1.1 FY2011'!$F:$F)","v":-20400},{"$f":"-SUMIF('1.2 FY2012'!$B:$B,'2.1 Database'!B43,'1.2 FY2012'!$F:$F)","v":-169489},{"$f":"-SUMIF('1.3 FY2013'!$B:$B,'2.1 Database'!B43,'1.3 FY2013'!$F:$F)","v":-61111.483999999997},null,"Other operating expenses",{"$f":"+COUNTIF('2.2 P&L statement'!$B$4:$B$24,'2.1 Database'!J43)","v":1}]
[null,"2079070000105",{"$f":"+VLOOKUP($B44,'1.1 FY2011'!$B$5:$E$61,2,FALSE)","v":"Misc extraordinary expenses"},{"$f":"+VLOOKUP($B44,'1.1 FY2011'!$B$5:$E$61,3,FALSE)","v":105},{"$f":"+VLOOKUP($B44,'1.1 FY2011'!$B$5:$E$61,4,FALSE)","v":"Generco Healthcare Ltd"},{"$f":"-SUMIF('1.1 FY2011'!$B:$B,'2.1 Database'!B44,'1.1 FY2011'!$F:$F)","v":0},{"$f":"-SUMIF('1.2 FY2012'!$B:$B,'2.1 Database'!B44,'1.2 FY2012'!$F:$F)","v":0},{"$f":"-SUMIF('1.3 FY2013'!$B:$B,'2.1 Database'!B44,'1.3 FY2013'!$F:$F)","v":-1684415.2999999998},null,"Other operating expenses",{"$f":"+COUNTIF('2.2 P&L statement'!$B$4:$B$24,'2.1 Database'!J44)","v":1}]
[null,"2079070000111111",{"$f":"+VLOOKUP($B45,'1.1 FY2011'!$B$5:$E$61,2,FALSE)","v":"Misc extraordinary expenses"},{"$f":"+VLOOKUP($B45,'1.1 FY2011'!$B$5:$E$61,3,FALSE)","v":111111},{"$f":"+VLOOKUP($B45,'1.1 FY2011'!$B$5:$E$61,4,FALSE)","v":"External"},{"$f":"-SUMIF('1.1 FY2011'!$B:$B,'2.1 Database'!B45,'1.1 FY2011'!$F:$F)","v":-563918.152},{"$f":"-SUMIF('1.2 FY2012'!$B:$B,'2.1 Database'!B45,'1.2 FY2012'!$F:$F)","v":-638869.13},{"$f":"-SUMIF('1.3 FY2013'!$B:$B,'2.1 Database'!B45,'1.3 FY2013'!$F:$F)","v":-575626.2649999999},null,"Other operating expenses",{"$f":"+COUNTIF('2.2 P&L statement'!$B$4:$B$24,'2.1 Database'!J45)","v":1}]
[null,"20790800001009",{"$f":"+VLOOKUP($B46,'1.1 FY2011'!$B$5:$E$61,2,FALSE)","v":"Difference from eliminations"},{"$f":"+VLOOKUP($B46,'1.1 FY2011'!$B$5:$E$61,3,FALSE)","v":1009},{"$f":"+VLOOKUP($B46,'1.1 FY2011'!$B$5:$E$61,4,FALSE)","v":"Green Ventures Ltd"},{"$f":"-SUMIF('1.1 FY2011'!$B:$B,'2.1 Database'!B46,'1.1 FY2011'!$F:$F)","v":0},{"$f":"-SUMIF('1.2 FY2012'!$B:$B,'2.1 Database'!B46,'1.2 FY2012'!$F:$F)","v":0},{"$f":"-SUMIF('1.3 FY2013'!$B:$B,'2.1 Database'!B46,'1.3 FY2013'!$F:$F)","v":0},null,0,{"$f":"+COUNTIF('2.2 P&L statement'!$B$4:$B$24,'2.1 Database'!J46)","v":0}]
[null,"20790800001007",{"$f":"+VLOOKUP($B47,'1.1 FY2011'!$B$5:$E$61,2,FALSE)","v":"Difference from eliminations"},{"$f":"+VLOOKUP($B47,'1.1 FY2011'!$B$5:$E$61,3,FALSE)","v":1007},{"$f":"+VLOOKUP($B47,'1.1 FY2011'!$B$5:$E$61,4,FALSE)","v":"Generco Sunshine JSC"},{"$f":"-SUMIF('1.1 FY2011'!$B:$B,'2.1 Database'!B47,'1.1 FY2011'!$F:$F)","v":0},{"$f":"-SUMIF('1.2 FY2012'!$B:$B,'2.1 Database'!B47,'1.2 FY2012'!$F:$F)","v":0},{"$f":"-SUMIF('1.3 FY2013'!$B:$B,'2.1 Database'!B47,'1.3 FY2013'!$F:$F)","v":0},null,0,{"$f":"+COUNTIF('2.2 P&L statement'!$B$4:$B$24,'2.1 Database'!J47)","v":0}]
[null,"20790800001008",{"$f":"+VLOOKUP($B48,'1.1 FY2011'!$B$5:$E$61,2,FALSE)","v":"Difference from eliminations"},{"$f":"+VLOOKUP($B48,'1.1 FY2011'!$B$5:$E$61,3,FALSE)","v":1008},{"$f":"+VLOOKUP($B48,'1.1 FY2011'!$B$5:$E$61,4,FALSE)","v":"Greenco Ltd"},{"$f":"-SUMIF('1.1 FY2011'!$B:$B,'2.1 Database'!B48,'1.1 FY2011'!$F:$F)","v":0},{"$f":"-SUMIF('1.2 FY2012'!$B:$B,'2.1 Database'!B48,'1.2 FY2012'!$F:$F)","v":0},{"$f":"-SUMIF('1.3 FY2013'!$B:$B,'2.1 Database'!B48,'1.3 FY2013'!$F:$F)","v":0},null,0,{"$f":"+COUNTIF('2.2 P&L statement'!$B$4:$B$24,'2.1 Database'!J48)","v":0}]
[null,"20822800001009",{"$f":"+VLOOKUP($B49,'1.1 FY2011'!$B$5:$E$61,2,FALSE)","v":"Interest income"},{"$f":"+VLOOKUP($B49,'1.1 FY2011'!$B$5:$E$61,3,FALSE)","v":1009},{"$f":"+VLOOKUP($B49,'1.1 FY2011'!$B$5:$E$61,4,FALSE)","v":"Green Ventures Ltd"},{"$f":"-SUMIF('1.1 FY2011'!$B:$B,'2.1 Database'!B49,'1.1 FY2011'!$F:$F)","v":0},{"$f":"-SUMIF('1.2 FY2012'!$B:$B,'2.1 Database'!B49,'1.2 FY2012'!$F:$F)","v":0},{"$f":"-SUMIF('1.3 FY2013'!$B:$B,'2.1 Database'!B49,'1.3 FY2013'!$F:$F)","v":0},null,"Financial items",{"$f":"+COUNTIF('2.2 P&L statement'!$B$4:$B$24,'2.1 Database'!J49)","v":1}]
[null,"20822800001007",{"$f":"+VLOOKUP($B50,'1.1 FY2011'!$B$5:$E$61,2,FALSE)","v":"Interest income"},{"$f":"+VLOOKUP($B50,'1.1 FY2011'!$B$5:$E$61,3,FALSE)","v":1007},{"$f":"+VLOOKUP($B50,'1.1 FY2011'!$B$5:$E$61,4,FALSE)","v":"Generco Sunshine JSC"},{"$f":"-SUMIF('1.1 FY2011'!$B:$B,'2.1 Database'!B50,'1.1 FY2011'!$F:$F)","v":0},{"$f":"-SUMIF('1.2 FY2012'!$B:$B,'2.1 Database'!B50,'1.2 FY2012'!$F:$F)","v":0},{"$f":"-SUMIF('1.3 FY2013'!$B:$B,'2.1 Database'!B50,'1.3 FY2013'!$F:$F)","v":0},null,"Financial items",{"$f":"+COUNTIF('2.2 P&L statement'!$B$4:$B$24,'2.1 Database'!J50)","v":1}]
[null,"20822800001008",{"$f":"+VLOOKUP($B51,'1.1 FY2011'!$B$5:$E$61,2,FALSE)","v":"Interest income"},{"$f":"+VLOOKUP($B51,'1.1 FY2011'!$B$5:$E$61,3,FALSE)","v":1008},{"$f":"+VLOOKUP($B51,'1.1 FY2011'!$B$5:$E$61,4,FALSE)","v":"Greenco Ltd"},{"$f":"-SUMIF('1.1 FY2011'!$B:$B,'2.1 Database'!B51,'1.1 FY2011'!$F:$F)","v":0},{"$f":"-SUMIF('1.2 FY2012'!$B:$B,'2.1 Database'!B51,'1.2 FY2012'!$F:$F)","v":0},{"$f":"-SUMIF('1.3 FY2013'!$B:$B,'2.1 Database'!B51,'1.3 FY2013'!$F:$F)","v":0},null,"Financial items",{"$f":"+COUNTIF('2.2 P&L statement'!$B$4:$B$24,'2.1 Database'!J51)","v":1}]
[null,"20822800001240",{"$f":"+VLOOKUP($B52,'1.1 FY2011'!$B$5:$E$61,2,FALSE)","v":"Interest income"},{"$f":"+VLOOKUP($B52,'1.1 FY2011'!$B$5:$E$61,3,FALSE)","v":1240},{"$f":"+VLOOKUP($B52,'1.1 FY2011'!$B$5:$E$61,4,FALSE)","v":"Generco UK "},{"$f":"-SUMIF('1.1 FY2011'!$B:$B,'2.1 Database'!B52,'1.1 FY2011'!$F:$F)","v":35810.228000000003},{"$f":"-SUMIF('1.2 FY2012'!$B:$B,'2.1 Database'!B52,'1.2 FY2012'!$F:$F)","v":34224.959999999999},{"$f":"-SUMIF('1.3 FY2013'!$B:$B,'2.1 Database'!B52,'1.3 FY2013'!$F:$F)","v":0},null,"Financial items",{"$f":"+COUNTIF('2.2 P&L statement'!$B$4:$B$24,'2.1 Database'!J52)","v":1}]
[null,"2082280000111111",{"$f":"+VLOOKUP($B53,'1.1 FY2011'!$B$5:$E$61,2,FALSE)","v":"Interest income"},{"$f":"+VLOOKUP($B53,'1.1 FY2011'!$B$5:$E$61,3,FALSE)","v":111111},{"$f":"+VLOOKUP($B53,'1.1 FY2011'!$B$5:$E$61,4,FALSE)","v":"External"},{"$f":"-SUMIF('1.1 FY2011'!$B:$B,'2.1 Database'!B53,'1.1 FY2011'!$F:$F)","v":51927.417999999998},{"$f":"-SUMIF('1.2 FY2012'!$B:$B,'2.1 Database'!B53,'1.2 FY2012'!$F:$F)","v":2204.7199999999998},{"$f":"-SUMIF('1.3 FY2013'!$B:$B,'2.1 Database'!B53,'1.3 FY2013'!$F:$F)","v":73809.511999999988},null,"Financial items",{"$f":"+COUNTIF('2.2 P&L statement'!$B$4:$B$24,'2.1 Database'!J53)","v":1}]
[null,"2082202000111101",{"$f":"+VLOOKUP($B54,'1.1 FY2011'!$B$5:$E$61,2,FALSE)","v":"Capitalized interest"},{"$f":"+VLOOKUP($B54,'1.1 FY2011'!$B$5:$E$61,3,FALSE)","v":111101},{"$f":"+VLOOKUP($B54,'1.1 FY2011'!$B$5:$E$61,4,FALSE)","v":"Not assigned"},{"$f":"-SUMIF('1.1 FY2011'!$B:$B,'2.1 Database'!B54,'1.1 FY2011'!$F:$F)","v":862270.63399999996},{"$f":"-SUMIF('1.2 FY2012'!$B:$B,'2.1 Database'!B54,'1.2 FY2012'!$F:$F)","v":0},{"$f":"-SUMIF('1.3 FY2013'!$B:$B,'2.1 Database'!B54,'1.3 FY2013'!$F:$F)","v":0},null,"Capitalized costs",{"$f":"+COUNTIF('2.2 P&L statement'!$B$4:$B$24,'2.1 Database'!J54)","v":1}]
[null,"2082208200111101",{"$f":"+VLOOKUP($B55,'1.1 FY2011'!$B$5:$E$61,2,FALSE)","v":"Non-recurring costs"},{"$f":"+VLOOKUP($B55,'1.1 FY2011'!$B$5:$E$61,3,FALSE)","v":111101},{"$f":"+VLOOKUP($B55,'1.1 FY2011'!$B$5:$E$61,4,FALSE)","v":"Not assigned"},{"$f":"-SUMIF('1.1 FY2011'!$B:$B,'2.1 Database'!B55,'1.1 FY2011'!$F:$F)","v":-22763},{"$f":"-SUMIF('1.2 FY2012'!$B:$B,'2.1 Database'!B55,'1.2 FY2012'!$F:$F)","v":-80617.179999999993},{"$f":"-SUMIF('1.3 FY2013'!$B:$B,'2.1 Database'!B55,'1.3 FY2013'!$F:$F)","v":-7173.195999999999},null,"Extraordinary items",{"$f":"+COUNTIF('2.2 P&L statement'!$B$4:$B$24,'2.1 Database'!J55)","v":1}]
[null,"208221400088",{"$f":"+VLOOKUP($B56,'1.1 FY2011'!$B$5:$E$61,2,FALSE)","v":"Interest expenses"},{"$f":"+VLOOKUP($B56,'1.1 FY2011'!$B$5:$E$61,3,FALSE)","v":88},{"$f":"+VLOOKUP($B56,'1.1 FY2011'!$B$5:$E$61,4,FALSE)","v":"Generco Ltd"},{"$f":"-SUMIF('1.1 FY2011'!$B:$B,'2.1 Database'!B56,'1.1 FY2011'!$F:$F)","v":-2930430.0120000001},{"$f":"-SUMIF('1.2 FY2012'!$B:$B,'2.1 Database'!B56,'1.2 FY2012'!$F:$F)","v":-2752704.22},{"$f":"-SUMIF('1.3 FY2013'!$B:$B,'2.1 Database'!B56,'1.3 FY2013'!$F:$F)","v":-2324465.8859999999},null,"Financial items",{"$f":"+COUNTIF('2.2 P&L statement'!$B$4:$B$24,'2.1 Database'!J56)","v":1}]
[null,"2091200000111101",{"$f":"+VLOOKUP($B57,'1.1 FY2011'!$B$5:$E$61,2,FALSE)","v":"Current taxes"},{"$f":"+VLOOKUP($B57,'1.1 FY2011'!$B$5:$E$61,3,FALSE)","v":111101},{"$f":"+VLOOKUP($B57,'1.1 FY2011'!$B$5:$E$61,4,FALSE)","v":"Not assigned"},{"$f":"-SUMIF('1.1 FY2011'!$B:$B,'2.1 Database'!B57,'1.1 FY2011'!$F:$F)","v":49378.641999999993},{"$f":"-SUMIF('1.2 FY2012'!$B:$B,'2.1 Database'!B57,'1.2 FY2012'!$F:$F)","v":-496748.70000000007},{"$f":"-SUMIF('1.3 FY2013'!$B:$B,'2.1 Database'!B57,'1.3 FY2013'!$F:$F)","v":-2558.1950000000002},null,"Taxes",{"$f":"+COUNTIF('2.2 P&L statement'!$B$4:$B$24,'2.1 Database'!J57)","v":1}]
[null,"2091200001111101",{"$f":"+VLOOKUP($B58,'1.1 FY2011'!$B$5:$E$61,2,FALSE)","v":"Regional taxes"},{"$f":"+VLOOKUP($B58,'1.1 FY2011'!$B$5:$E$61,3,FALSE)","v":111101},{"$f":"+VLOOKUP($B58,'1.1 FY2011'!$B$5:$E$61,4,FALSE)","v":"Not assigned"},{"$f":"-SUMIF('1.1 FY2011'!$B:$B,'2.1 Database'!B58,'1.1 FY2011'!$F:$F)","v":-516250.67},{"$f":"-SUMIF('1.2 FY2012'!$B:$B,'2.1 Database'!B58,'1.2 FY2012'!$F:$F)","v":-480872.96000000002},{"$f":"-SUMIF('1.3 FY2013'!$B:$B,'2.1 Database'!B58,'1.3 FY2013'!$F:$F)","v":-522710.353},null,"Taxes",{"$f":"+COUNTIF('2.2 P&L statement'!$B$4:$B$24,'2.1 Database'!J58)","v":1}]
[null,"2092200000111101",{"$f":"+VLOOKUP($B59,'1.1 FY2011'!$B$5:$E$61,2,FALSE)","v":"Deferred taxes"},{"$f":"+VLOOKUP($B59,'1.1 FY2011'!$B$5:$E$61,3,FALSE)","v":111101},{"$f":"+VLOOKUP($B59,'1.1 FY2011'!$B$5:$E$61,4,FALSE)","v":"Not assigned"},{"$f":"-SUMIF('1.1 FY2011'!$B:$B,'2.1 Database'!B59,'1.1 FY2011'!$F:$F)","v":-21593.093999999997},{"$f":"-SUMIF('1.2 FY2012'!$B:$B,'2.1 Database'!B59,'1.2 FY2012'!$F:$F)","v":-6570.3050000000003},{"$f":"-SUMIF('1.3 FY2013'!$B:$B,'2.1 Database'!B59,'1.3 FY2013'!$F:$F)","v":160303.52199999997},null,"Taxes",{"$f":"+COUNTIF('2.2 P&L statement'!$B$4:$B$24,'2.1 Database'!J59)","v":1}]
[null,"2999999999111101",{"$f":"+VLOOKUP($B60,'1.1 FY2011'!$B$5:$E$61,2,FALSE)","v":"Net income/(loss)"},{"$f":"+VLOOKUP($B60,'1.1 FY2011'!$B$5:$E$61,3,FALSE)","v":111101},{"$f":"+VLOOKUP($B60,'1.1 FY2011'!$B$5:$E$61,4,FALSE)","v":"Not assigned"},{"$f":"SUMIF('1.1 FY2011'!$B:$B,'2.1 Database'!B60,'1.1 FY2011'!$F:$F)","v":-2904117.9939999986},{"$f":"SUMIF('1.2 FY2012'!$B:$B,'2.1 Database'!B60,'1.2 FY2012'!$F:$F)","v":0},{"$f":"SUMIF('1.3 FY2013'!$B:$B,'2.1 Database'!B60,'1.3 FY2013'!$F:$F)","v":0},null,"Net Income",{"$f":"+COUNTIF('2.2 P&L statement'!$B$4:$B$24,'2.1 Database'!J60)","v":1}]
[null,"2001110000105",{"$f":"VLOOKUP($B61,'1.2 FY2012'!$B$5:$E$86,2,FALSE)","v":"Core business revenues"},{"$f":"VLOOKUP($B61,'1.2 FY2012'!$B$5:$E$86,3,FALSE)","v":105},{"$f":"VLOOKUP($B61,'1.2 FY2012'!$B$5:$E$86,4,FALSE)","v":"Generco Healthcare Ltd"},{"$f":"-SUMIF('1.1 FY2011'!$B:$B,'2.1 Database'!B61,'1.1 FY2011'!$F:$F)","v":0},{"$f":"-SUMIF('1.2 FY2012'!$B:$B,'2.1 Database'!B61,'1.2 FY2012'!$F:$F)","v":355396.61499999999},{"$f":"-SUMIF('1.3 FY2013'!$B:$B,'2.1 Database'!B61,'1.3 FY2013'!$F:$F)","v":616462.01899999997},null,"Net sales",{"$f":"+COUNTIF('2.2 P&L statement'!$B$4:$B$24,'2.1 Database'!J61)","v":1}]
[null,"20200000001086",{"$f":"VLOOKUP($B62,'1.2 FY2012'!$B$5:$E$86,2,FALSE)","v":"Capitalized costs"},{"$f":"VLOOKUP($B62,'1.2 FY2012'!$B$5:$E$86,3,FALSE)","v":"1086"},{"$f":"VLOOKUP($B62,'1.2 FY2012'!$B$5:$E$86,4,FALSE)","v":"G&Resources Ltd"},{"$f":"-SUMIF('1.1 FY2011'!$B:$B,'2.1 Database'!B62,'1.1 FY2011'!$F:$F)","v":0},{"$f":"-SUMIF('1.2 FY2012'!$B:$B,'2.1 Database'!B62,'1.2 FY2012'!$F:$F)","v":420017.14999999997},{"$f":"-SUMIF('1.3 FY2013'!$B:$B,'2.1 Database'!B62,'1.3 FY2013'!$F:$F)","v":0},null,"Capitalized costs",{"$f":"+COUNTIF('2.2 P&L statement'!$B$4:$B$24,'2.1 Database'!J62)","v":1}]
[null,"2021210000111111",{"$f":"VLOOKUP($B63,'1.2 FY2012'!$B$5:$E$86,2,FALSE)","v":"Utility charges"},{"$f":"VLOOKUP($B63,'1.2 FY2012'!$B$5:$E$86,3,FALSE)","v":111111},{"$f":"VLOOKUP($B63,'1.2 FY2012'!$B$5:$E$86,4,FALSE)","v":"External"},{"$f":"-SUMIF('1.1 FY2011'!$B:$B,'2.1 Database'!B63,'1.1 FY2011'!$F:$F)","v":0},{"$f":"-SUMIF('1.2 FY2012'!$B:$B,'2.1 Database'!B63,'1.2 FY2012'!$F:$F)","v":-14589.33},{"$f":"-SUMIF('1.3 FY2013'!$B:$B,'2.1 Database'!B63,'1.3 FY2013'!$F:$F)","v":-20504.509999999998},null,"Other operating expenses",{"$f":"+COUNTIF('2.2 P&L statement'!$B$4:$B$24,'2.1 Database'!J63)","v":1}]
[null,"202409000019",{"$f":"VLOOKUP($B64,'1.2 FY2012'!$B$5:$E$86,2,FALSE)","v":"R&D expenses"},{"$f":"VLOOKUP($B64,'1.2 FY2012'!$B$5:$E$86,3,FALSE)","v":19},{"$f":"VLOOKUP($B64,'1.2 FY2012'!$B$5:$E$86,4,FALSE)","v":"Generco Cosmetics Ltd"},{"$f":"-SUMIF('1.1 FY2011'!$B:$B,'2.1 Database'!B64,'1.1 FY2011'!$F:$F)","v":0},{"$f":"-SUMIF('1.2 FY2012'!$B:$B,'2.1 Database'!B64,'1.2 FY2012'!$F:$F)","v":-38521},{"$f":"-SUMIF('1.3 FY2013'!$B:$B,'2.1 Database'!B64,'1.3 FY2013'!$F:$F)","v":0},null,"Other operating expenses",{"$f":"+COUNTIF('2.2 P&L statement'!$B$4:$B$24,'2.1 Database'!J64)","v":1}]
[null,"20240900001283",{"$f":"VLOOKUP($B65,'1.2 FY2012'!$B$5:$E$86,2,FALSE)","v":"R&D expenses"},{"$f":"VLOOKUP($B65,'1.2 FY2012'!$B$5:$E$86,3,FALSE)","v":"1283"},{"$f":"VLOOKUP($B65,'1.2 FY2012'!$B$5:$E$86,4,FALSE)","v":"Generco Ventures Ltd"},{"$f":"-SUMIF('1.1 FY2011'!$B:$B,'2.1 Database'!B65,'1.1 FY2011'!$F:$F)","v":0},{"$f":"-SUMIF('1.2 FY2012'!$B:$B,'2.1 Database'!B65,'1.2 FY2012'!$F:$F)","v":-1820},{"$f":"-SUMIF('1.3 FY2013'!$B:$B,'2.1 Database'!B65,'1.3 FY2013'!$F:$F)","v":0},null,"Other operating expenses",{"$f":"+COUNTIF('2.2 P&L statement'!$B$4:$B$24,'2.1 Database'!J65)","v":1}]
[null,"20240900001924",{"$f":"VLOOKUP($B66,'1.2 FY2012'!$B$5:$E$86,2,FALSE)","v":"R&D expenses"},{"$f":"VLOOKUP($B66,'1.2 FY2012'!$B$5:$E$86,3,FALSE)","v":"1924"},{"$f":"VLOOKUP($B66,'1.2 FY2012'!$B$5:$E$86,4,FALSE)","v":"Generco Infrastructure Ltd"},{"$f":"-SUMIF('1.1 FY2011'!$B:$B,'2.1 Database'!B66,'1.1 FY2011'!$F:$F)","v":0},{"$f":"-SUMIF('1.2 FY2012'!$B:$B,'2.1 Database'!B66,'1.2 FY2012'!$F:$F)","v":-10448.129999999999},{"$f":"-SUMIF('1.3 FY2013'!$B:$B,'2.1 Database'!B66,'1.3 FY2013'!$F:$F)","v":-673.34299999999985},null,"Other operating expenses",{"$f":"+COUNTIF('2.2 P&L statement'!$B$4:$B$24,'2.1 Database'!J66)","v":1}]
[null,"20240900002486",{"$f":"VLOOKUP($B67,'1.2 FY2012'!$B$5:$E$86,2,FALSE)","v":"R&D expenses"},{"$f":"VLOOKUP($B67,'1.2 FY2012'!$B$5:$E$86,3,FALSE)","v":"2486"},{"$f":"VLOOKUP($B67,'1.2 FY2012'!$B$5:$E$86,4,FALSE)","v":"Generco Exloration Ltd"},{"$f":"-SUMIF('1.1 FY2011'!$B:$B,'2.1 Database'!B67,'1.1 FY2011'!$F:$F)","v":0},{"$f":"-SUMIF('1.2 FY2012'!$B:$B,'2.1 Database'!B67,'1.2 FY2012'!$F:$F)","v":-10412.5},{"$f":"-SUMIF('1.3 FY2013'!$B:$B,'2.1 Database'!B67,'1.3 FY2013'!$F:$F)","v":0},null,"Other operating expenses",{"$f":"+COUNTIF('2.2 P&L statement'!$B$4:$B$24,'2.1 Database'!J67)","v":1}]
[null,"2049000000111101",{"$f":"VLOOKUP($B68,'1.2 FY2012'!$B$5:$E$86,2,FALSE)","v":"Other personnel expenses"},{"$f":"VLOOKUP($B68,'1.2 FY2012'!$B$5:$E$86,3,FALSE)","v":111101},{"$f":"VLOOKUP($B68,'1.2 FY2012'!$B$5:$E$86,4,FALSE)","v":"Not assigned"},{"$f":"-SUMIF('1.1 FY2011'!$B:$B,'2.1 Database'!B68,'1.1 FY2011'!$F:$F)","v":0},{"$f":"-SUMIF('1.2 FY2012'!$B:$B,'2.1 Database'!B68,'1.2 FY2012'!$F:$F)","v":-6919.8499999999995},{"$f":"-SUMIF('1.3 FY2013'!$B:$B,'2.1 Database'!B68,'1.3 FY2013'!$F:$F)","v":0},null,"Personnel expenses",{"$f":"+COUNTIF('2.2 P&L statement'!$B$4:$B$24,'2.1 Database'!J68)","v":1}]
[null,"2060220000111111",{"$f":"VLOOKUP($B69,'1.2 FY2012'!$B$5:$E$86,2,FALSE)","v":"Gains from disposal of PP&E"},{"$f":"VLOOKUP($B69,'1.2 FY2012'!$B$5:$E$86,3,FALSE)","v":111111},{"$f":"VLOOKUP($B69,'1.2 FY2012'!$B$5:$E$86,4,FALSE)","v":"External"},{"$f":"-SUMIF('1.1 FY2011'!$B:$B,'2.1 Database'!B69,'1.1 FY2011'!$F:$F)","v":0},{"$f":"-SUMIF('1.2 FY2012'!$B:$B,'2.1 Database'!B69,'1.2 FY2012'!$F:$F)","v":121553.07499999998},{"$f":"-SUMIF('1.3 FY2013'!$B:$B,'2.1 Database'!B69,'1.3 FY2013'!$F:$F)","v":0},null,"Extraordinary items",{"$f":"+COUNTIF('2.2 P&L statement'!$B$4:$B$24,'2.1 Database'!J69)","v":1}]
[null,"206901000019",{"$f":"VLOOKUP($B70,'1.2 FY2012'!$B$5:$E$86,2,FALSE)","v":"Corporate recharges"},{"$f":"VLOOKUP($B70,'1.2 FY2012'!$B$5:$E$86,3,FALSE)","v":19},{"$f":"VLOOKUP($B70,'1.2 FY2012'!$B$5:$E$86,4,FALSE)","v":"Generco Cosmetics Ltd"},{"$f":"-SUMIF('1.1 FY2011'!$B:$B,'2.1 Database'!B70,'1.1 FY2011'!$F:$F)","v":0},{"$f":"-SUMIF('1.2 FY2012'!$B:$B,'2.1 Database'!B70,'1.2 FY2012'!$F:$F)","v":416278.66},{"$f":"-SUMIF('1.3 FY2013'!$B:$B,'2.1 Database'!B70,'1.3 FY2013'!$F:$F)","v":622966.38600000006},null,"Recharges",{"$f":"+COUNTIF('2.2 P&L statement'!$B$4:$B$24,'2.1 Database'!J70)","v":1}]
[null,"20690100001076",{"$f":"VLOOKUP($B71,'1.2 FY2012'!$B$5:$E$86,2,FALSE)","v":"Corporate recharges"},{"$f":"VLOOKUP($B71,'1.2 FY2012'!$B$5:$E$86,3,FALSE)","v":"1076"},{"$f":"VLOOKUP($B71,'1.2 FY2012'!$B$5:$E$86,4,FALSE)","v":"Generco Trading Ltd"},{"$f":"-SUMIF('1.1 FY2011'!$B:$B,'2.1 Database'!B71,'1.1 FY2011'!$F:$F)","v":0},{"$f":"-SUMIF('1.2 FY2012'!$B:$B,'2.1 Database'!B71,'1.2 FY2012'!$F:$F)","v":364243.84499999997},{"$f":"-SUMIF('1.3 FY2013'!$B:$B,'2.1 Database'!B71,'1.3 FY2013'!$F:$F)","v":0},null,"Recharges",{"$f":"+COUNTIF('2.2 P&L statement'!$B$4:$B$24,'2.1 Database'!J71)","v":1}]
[null,"20690100001086",{"$f":"VLOOKUP($B72,'1.2 FY2012'!$B$5:$E$86,2,FALSE)","v":"Corporate recharges"},{"$f":"VLOOKUP($B72,'1.2 FY2012'!$B$5:$E$86,3,FALSE)","v":"1086"},{"$f":"VLOOKUP($B72,'1.2 FY2012'!$B$5:$E$86,4,FALSE)","v":"G&Resources Ltd"},{"$f":"-SUMIF('1.1 FY2011'!$B:$B,'2.1 Database'!B72,'1.1 FY2011'!$F:$F)","v":0},{"$f":"-SUMIF('1.2 FY2012'!$B:$B,'2.1 Database'!B72,'1.2 FY2012'!$F:$F)","v":0},{"$f":"-SUMIF('1.3 FY2013'!$B:$B,'2.1 Database'!B72,'1.3 FY2013'!$F:$F)","v":0},null,"Recharges",{"$f":"+COUNTIF('2.2 P&L statement'!$B$4:$B$24,'2.1 Database'!J72)","v":1}]
[null,"206901000047037",{"$f":"VLOOKUP($B73,'1.2 FY2012'!$B$5:$E$86,2,FALSE)","v":"Corporate recharges"},{"$f":"VLOOKUP($B73,'1.2 FY2012'!$B$5:$E$86,3,FALSE)","v":"47037"},{"$f":"VLOOKUP($B73,'1.2 FY2012'!$B$5:$E$86,4,FALSE)","v":"G&CR Global Ltd"},{"$f":"-SUMIF('1.1 FY2011'!$B:$B,'2.1 Database'!B73,'1.1 FY2011'!$F:$F)","v":0},{"$f":"-SUMIF('1.2 FY2012'!$B:$B,'2.1 Database'!B73,'1.2 FY2012'!$F:$F)","v":482611.04499999998},{"$f":"-SUMIF('1.3 FY2013'!$B:$B,'2.1 Database'!B73,'1.3 FY2013'!$F:$F)","v":1948832.1429999999},null,"Recharges",{"$f":"+COUNTIF('2.2 P&L statement'!$B$4:$B$24,'2.1 Database'!J73)","v":1}]
[null,"206998000088",{"$f":"VLOOKUP($B74,'1.2 FY2012'!$B$5:$E$86,2,FALSE)","v":"Other income"},{"$f":"VLOOKUP($B74,'1.2 FY2012'!$B$5:$E$86,3,FALSE)","v":88},{"$f":"VLOOKUP($B74,'1.2 FY2012'!$B$5:$E$86,4,FALSE)","v":"Generco Ltd"},{"$f":"-SUMIF('1.1 FY2011'!$B:$B,'2.1 Database'!B74,'1.1 FY2011'!$F:$F)","v":0},{"$f":"-SUMIF('1.2 FY2012'!$B:$B,'2.1 Database'!B74,'1.2 FY2012'!$F:$F)","v":2436.35},{"$f":"-SUMIF('1.3 FY2013'!$B:$B,'2.1 Database'!B74,'1.3 FY2013'!$F:$F)","v":0},null,"Other income",{"$f":"+COUNTIF('2.2 P&L statement'!$B$4:$B$24,'2.1 Database'!J74)","v":1}]
[null,"2070290000111101",{"$f":"VLOOKUP($B75,'1.2 FY2012'!$B$5:$E$86,2,FALSE)","v":"Concession fees other"},{"$f":"VLOOKUP($B75,'1.2 FY2012'!$B$5:$E$86,3,FALSE)","v":111101},{"$f":"VLOOKUP($B75,'1.2 FY2012'!$B$5:$E$86,4,FALSE)","v":"Not assigned"},{"$f":"-SUMIF('1.1 FY2011'!$B:$B,'2.1 Database'!B75,'1.1 FY2011'!$F:$F)","v":0},{"$f":"-SUMIF('1.2 FY2012'!$B:$B,'2.1 Database'!B75,'1.2 FY2012'!$F:$F)","v":-81.339999999999989},{"$f":"-SUMIF('1.3 FY2013'!$B:$B,'2.1 Database'!B75,'1.3 FY2013'!$F:$F)","v":0},null,"Other operating expenses",{"$f":"+COUNTIF('2.2 P&L statement'!$B$4:$B$24,'2.1 Database'!J75)","v":1}]
[null,"2070900000105",{"$f":"VLOOKUP($B76,'1.2 FY2012'!$B$5:$E$86,2,FALSE)","v":"Service expenses"},{"$f":"VLOOKUP($B76,'1.2 FY2012'!$B$5:$E$86,3,FALSE)","v":105},{"$f":"VLOOKUP($B76,'1.2 FY2012'!$B$5:$E$86,4,FALSE)","v":"Generco Healthcare Ltd"},{"$f":"-SUMIF('1.1 FY2011'!$B:$B,'2.1 Database'!B76,'1.1 FY2011'!$F:$F)","v":0},{"$f":"-SUMIF('1.2 FY2012'!$B:$B,'2.1 Database'!B76,'1.2 FY2012'!$F:$F)","v":-276920},{"$f":"-SUMIF('1.3 FY2013'!$B:$B,'2.1 Database'!B76,'1.3 FY2013'!$F:$F)","v":-473575.46100000001},null,"Services",{"$f":"+COUNTIF('2.2 P&L statement'!$B$4:$B$24,'2.1 Database'!J76)","v":1}]
[null,"20711000001900",{"$f":"VLOOKUP($B77,'1.2 FY2012'!$B$5:$E$86,2,FALSE)","v":"Insurance expenses"},{"$f":"VLOOKUP($B77,'1.2 FY2012'!$B$5:$E$86,3,FALSE)","v":1900},{"$f":"VLOOKUP($B77,'1.2 FY2012'!$B$5:$E$86,4,FALSE)","v":"Generco Metals Gm"},{"$f":"-SUMIF('1.1 FY2011'!$B:$B,'2.1 Database'!B77,'1.1 FY2011'!$F:$F)","v":0},{"$f":"-SUMIF('1.2 FY2012'!$B:$B,'2.1 Database'!B77,'1.2 FY2012'!$F:$F)","v":0},{"$f":"-SUMIF('1.3 FY2013'!$B:$B,'2.1 Database'!B77,'1.3 FY2013'!$F:$F)","v":0},null,0,{"$f":"+COUNTIF('2.2 P&L statement'!$B$4:$B$24,'2.1 Database'!J77)","v":0}]
[null,"20712092001118",{"$f":"VLOOKUP($B78,'1.2 FY2012'!$B$5:$E$86,2,FALSE)","v":"Travel expenses"},{"$f":"VLOOKUP($B78,'1.2 FY2012'!$B$5:$E$86,3,FALSE)","v":"1118"},{"$f":"VLOOKUP($B78,'1.2 FY2012'!$B$5:$E$86,4,FALSE)","v":"Gener Green LLC"},{"$f":"-SUMIF('1.1 FY2011'!$B:$B,'2.1 Database'!B78,'1.1 FY2011'!$F:$F)","v":0},{"$f":"-SUMIF('1.2 FY2012'!$B:$B,'2.1 Database'!B78,'1.2 FY2012'!$F:$F)","v":-23928.799999999999},{"$f":"-SUMIF('1.3 FY2013'!$B:$B,'2.1 Database'!B78,'1.3 FY2013'!$F:$F)","v":0},null,"Other operating expenses",{"$f":"+COUNTIF('2.2 P&L statement'!$B$4:$B$24,'2.1 Database'!J78)","v":1}]
[null,"2071220000111111",{"$f":"VLOOKUP($B79,'1.2 FY2012'!$B$5:$E$86,2,FALSE)","v":"Losses fr disposal of PPE"},{"$f":"VLOOKUP($B79,'1.2 FY2012'!$B$5:$E$86,3,FALSE)","v":111111},{"$f":"VLOOKUP($B79,'1.2 FY2012'!$B$5:$E$86,4,FALSE)","v":"External"},{"$f":"-SUMIF('1.1 FY2011'!$B:$B,'2.1 Database'!B79,'1.1 FY2011'!$F:$F)","v":0},{"$f":"-SUMIF('1.2 FY2012'!$B:$B,'2.1 Database'!B79,'1.2 FY2012'!$F:$F)","v":-308232},{"$f":"-SUMIF('1.3 FY2013'!$B:$B,'2.1 Database'!B79,'1.3 FY2013'!$F:$F)","v":0},null,"Extraordinary items",{"$f":"+COUNTIF('2.2 P&L statement'!$B$4:$B$24,'2.1 Database'!J79)","v":1}]
[null,"207151100019",{"$f":"VLOOKUP($B80,'1.2 FY2012'!$B$5:$E$86,2,FALSE)","v":"Other operative currency differences"},{"$f":"VLOOKUP($B80,'1.2 FY2012'!$B$5:$E$86,3,FALSE)","v":19},{"$f":"VLOOKUP($B80,'1.2 FY2012'!$B$5:$E$86,4,FALSE)","v":"Generco Cosmetics Ltd"},{"$f":"-SUMIF('1.1 FY2011'!$B:$B,'2.1 Database'!B80,'1.1 FY2011'!$F:$F)","v":0},{"$f":"-SUMIF('1.2 FY2012'!$B:$B,'2.1 Database'!B80,'1.2 FY2012'!$F:$F)","v":-13422.779999999999},{"$f":"-SUMIF('1.3 FY2013'!$B:$B,'2.1 Database'!B80,'1.3 FY2013'!$F:$F)","v":0},null,"Other operating expenses",{"$f":"+COUNTIF('2.2 P&L statement'!$B$4:$B$24,'2.1 Database'!J80)","v":1}]
[null,"2071511000111111",{"$f":"VLOOKUP($B81,'1.2 FY2012'!$B$5:$E$86,2,FALSE)","v":"Other operative currency differences"},{"$f":"VLOOKUP($B81,'1.2 FY2012'!$B$5:$E$86,3,FALSE)","v":111111},{"$f":"VLOOKUP($B81,'1.2 FY2012'!$B$5:$E$86,4,FALSE)","v":"External"},{"$f":"-SUMIF('1.1 FY2011'!$B:$B,'2.1 Database'!B81,'1.1 FY2011'!$F:$F)","v":0},{"$f":"-SUMIF('1.2 FY2012'!$B:$B,'2.1 Database'!B81,'1.2 FY2012'!$F:$F)","v":-4045.6150000000002},{"$f":"-SUMIF('1.3 FY2013'!$B:$B,'2.1 Database'!B81,'1.3 FY2013'!$F:$F)","v":0},null,"Other operating expenses",{"$f":"+COUNTIF('2.2 P&L statement'!$B$4:$B$24,'2.1 Database'!J81)","v":1}]
[null,"2071910000111111",{"$f":"VLOOKUP($B82,'1.2 FY2012'!$B$5:$E$86,2,FALSE)","v":"Property tax"},{"$f":"VLOOKUP($B82,'1.2 FY2012'!$B$5:$E$86,3,FALSE)","v":111111},{"$f":"VLOOKUP($B82,'1.2 FY2012'!$B$5:$E$86,4,FALSE)","v":"External"},{"$f":"-SUMIF('1.1 FY2011'!$B:$B,'2.1 Database'!B82,'1.1 FY2011'!$F:$F)","v":0},{"$f":"-SUMIF('1.2 FY2012'!$B:$B,'2.1 Database'!B82,'1.2 FY2012'!$F:$F)","v":-49621.144999999997},{"$f":"-SUMIF('1.3 FY2013'!$B:$B,'2.1 Database'!B82,'1.3 FY2013'!$F:$F)","v":0},null,"Other operating expenses",{"$f":"+COUNTIF('2.2 P&L statement'!$B$4:$B$24,'2.1 Database'!J82)","v":1}]
[null,"207907000019",{"$f":"VLOOKUP($B83,'1.2 FY2012'!$B$5:$E$86,2,FALSE)","v":"Misc extraordinary expenses"},{"$f":"VLOOKUP($B83,'1.2 FY2012'!$B$5:$E$86,3,FALSE)","v":19},{"$f":"VLOOKUP($B83,'1.2 FY2012'!$B$5:$E$86,4,FALSE)","v":"Generco Cosmetics Ltd"},{"$f":"-SUMIF('1.1 FY2011'!$B:$B,'2.1 Database'!B83,'1.1 FY2011'!$F:$F)","v":0},{"$f":"-SUMIF('1.2 FY2012'!$B:$B,'2.1 Database'!B83,'1.2 FY2012'!$F:$F)","v":-85462.684999999998},{"$f":"-SUMIF('1.3 FY2013'!$B:$B,'2.1 Database'!B83,'1.3 FY2013'!$F:$F)","v":0},null,"Extraordinary items",{"$f":"+COUNTIF('2.2 P&L statement'!$B$4:$B$24,'2.1 Database'!J83)","v":1}]
[null,"207907000043",{"$f":"VLOOKUP($B84,'1.2 FY2012'!$B$5:$E$86,2,FALSE)","v":"Misc extraordinary expenses"},{"$f":"VLOOKUP($B84,'1.2 FY2012'!$B$5:$E$86,3,FALSE)","v":"43"},{"$f":"VLOOKUP($B84,'1.2 FY2012'!$B$5:$E$86,4,FALSE)","v":"Greeny France SL"},{"$f":"-SUMIF('1.1 FY2011'!$B:$B,'2.1 Database'!B84,'1.1 FY2011'!$F:$F)","v":0},{"$f":"-SUMIF('1.2 FY2012'!$B:$B,'2.1 Database'!B84,'1.2 FY2012'!$F:$F)","v":-11422.144999999999},{"$f":"-SUMIF('1.3 FY2013'!$B:$B,'2.1 Database'!B84,'1.3 FY2013'!$F:$F)","v":0},null,"Extraordinary items",{"$f":"+COUNTIF('2.2 P&L statement'!$B$4:$B$24,'2.1 Database'!J84)","v":1}]
[null,"20790700001924",{"$f":"VLOOKUP($B85,'1.2 FY2012'!$B$5:$E$86,2,FALSE)","v":"Misc extraordinary expenses"},{"$f":"VLOOKUP($B85,'1.2 FY2012'!$B$5:$E$86,3,FALSE)","v":"1924"},{"$f":"VLOOKUP($B85,'1.2 FY2012'!$B$5:$E$86,4,FALSE)","v":"Generco Infrastructure Ltd"},{"$f":"-SUMIF('1.1 FY2011'!$B:$B,'2.1 Database'!B85,'1.1 FY2011'!$F:$F)","v":0},{"$f":"-SUMIF('1.2 FY2012'!$B:$B,'2.1 Database'!B85,'1.2 FY2012'!$F:$F)","v":-84438.864999999991},{"$f":"-SUMIF('1.3 FY2013'!$B:$B,'2.1 Database'!B85,'1.3 FY2013'!$F:$F)","v":0},null,"Extraordinary items",{"$f":"+COUNTIF('2.2 P&L statement'!$B$4:$B$24,'2.1 Database'!J85)","v":1}]
[null,"20790800001086",{"$f":"VLOOKUP($B86,'1.2 FY2012'!$B$5:$E$86,2,FALSE)","v":"Difference from eliminations"},{"$f":"VLOOKUP($B86,'1.2 FY2012'!$B$5:$E$86,3,FALSE)","v":"1086"},{"$f":"VLOOKUP($B86,'1.2 FY2012'!$B$5:$E$86,4,FALSE)","v":"G&Resources Ltd"},{"$f":"-SUMIF('1.1 FY2011'!$B:$B,'2.1 Database'!B86,'1.1 FY2011'!$F:$F)","v":0},{"$f":"-SUMIF('1.2 FY2012'!$B:$B,'2.1 Database'!B86,'1.2 FY2012'!$F:$F)","v":0},{"$f":"-SUMIF('1.3 FY2013'!$B:$B,'2.1 Database'!B86,'1.3 FY2013'!$F:$F)","v":0},null,0,{"$f":"+COUNTIF('2.2 P&L statement'!$B$4:$B$24,'2.1 Database'!J86)","v":0}]
[null,"20822800001086",{"$f":"VLOOKUP($B87,'1.2 FY2012'!$B$5:$E$86,2,FALSE)","v":"Interest income"},{"$f":"VLOOKUP($B87,'1.2 FY2012'!$B$5:$E$86,3,FALSE)","v":"1086"},{"$f":"VLOOKUP($B87,'1.2 FY2012'!$B$5:$E$86,4,FALSE)","v":"G&Resources Ltd"},{"$f":"-SUMIF('1.1 FY2011'!$B:$B,'2.1 Database'!B87,'1.1 FY2011'!$F:$F)","v":0},{"$f":"-SUMIF('1.2 FY2012'!$B:$B,'2.1 Database'!B87,'1.2 FY2012'!$F:$F)","v":0},{"$f":"-SUMIF('1.3 FY2013'!$B:$B,'2.1 Database'!B87,'1.3 FY2013'!$F:$F)","v":0},null,"Financial items",{"$f":"+COUNTIF('2.2 P&L statement'!$B$4:$B$24,'2.1 Database'!J87)","v":1}]
[null,"20822800001006",{"$f":"VLOOKUP($B88,'1.2 FY2012'!$B$5:$E$86,2,FALSE)","v":"Interest income"},{"$f":"VLOOKUP($B88,'1.2 FY2012'!$B$5:$E$86,3,FALSE)","v":1006},{"$f":"VLOOKUP($B88,'1.2 FY2012'!$B$5:$E$86,4,FALSE)","v":"Generco Mining GmbH"},{"$f":"-SUMIF('1.1 FY2011'!$B:$B,'2.1 Database'!B88,'1.1 FY2011'!$F:$F)","v":0},{"$f":"-SUMIF('1.2 FY2012'!$B:$B,'2.1 Database'!B88,'1.2 FY2012'!$F:$F)","v":6778.415},{"$f":"-SUMIF('1.3 FY2013'!$B:$B,'2.1 Database'!B88,'1.3 FY2013'!$F:$F)","v":0},null,"Financial items",{"$f":"+COUNTIF('2.2 P&L statement'!$B$4:$B$24,'2.1 Database'!J88)","v":1}]
[null,"20822140001007",{"$f":"VLOOKUP($B89,'1.2 FY2012'!$B$5:$E$86,2,FALSE)","v":"Interest expenses"},{"$f":"VLOOKUP($B89,'1.2 FY2012'!$B$5:$E$86,3,FALSE)","v":1007},{"$f":"VLOOKUP($B89,'1.2 FY2012'!$B$5:$E$86,4,FALSE)","v":"Generco Semiconductors Ltd"},{"$f":"-SUMIF('1.1 FY2011'!$B:$B,'2.1 Database'!B89,'1.1 FY2011'!$F:$F)","v":0},{"$f":"-SUMIF('1.2 FY2012'!$B:$B,'2.1 Database'!B89,'1.2 FY2012'!$F:$F)","v":0},{"$f":"-SUMIF('1.3 FY2013'!$B:$B,'2.1 Database'!B89,'1.3 FY2013'!$F:$F)","v":0},null,"Financial items",{"$f":"+COUNTIF('2.2 P&L statement'!$B$4:$B$24,'2.1 Database'!J89)","v":1}]
[null,"2082214000111111",{"$f":"VLOOKUP($B90,'1.2 FY2012'!$B$5:$E$86,2,FALSE)","v":"Interest expenses"},{"$f":"VLOOKUP($B90,'1.2 FY2012'!$B$5:$E$86,3,FALSE)","v":111111},{"$f":"VLOOKUP($B90,'1.2 FY2012'!$B$5:$E$86,4,FALSE)","v":"External"},{"$f":"-SUMIF('1.1 FY2011'!$B:$B,'2.1 Database'!B90,'1.1 FY2011'!$F:$F)","v":0},{"$f":"-SUMIF('1.2 FY2012'!$B:$B,'2.1 Database'!B90,'1.2 FY2012'!$F:$F)","v":-1250.7950000000001},{"$f":"-SUMIF('1.3 FY2013'!$B:$B,'2.1 Database'!B90,'1.3 FY2013'!$F:$F)","v":-51.454999999999998},null,"Financial items",{"$f":"+COUNTIF('2.2 P&L statement'!$B$4:$B$24,'2.1 Database'!J90)","v":1}]
[null,"20821100001240",{"$f":"VLOOKUP($B91,'1.2 FY2012'!$B$5:$E$86,2,FALSE)","v":"Impairment of participation"},{"$f":"VLOOKUP($B91,'1.2 FY2012'!$B$5:$E$86,3,FALSE)","v":1240},{"$f":"VLOOKUP($B91,'1.2 FY2012'!$B$5:$E$86,4,FALSE)","v":"Generco UK "},{"$f":"-SUMIF('1.1 FY2011'!$B:$B,'2.1 Database'!B91,'1.1 FY2011'!$F:$F)","v":0},{"$f":"-SUMIF('1.2 FY2012'!$B:$B,'2.1 Database'!B91,'1.2 FY2012'!$F:$F)","v":-4130000},{"$f":"-SUMIF('1.3 FY2013'!$B:$B,'2.1 Database'!B91,'1.3 FY2013'!$F:$F)","v":0},null,"Extraordinary items",{"$f":"+COUNTIF('2.2 P&L statement'!$B$4:$B$24,'2.1 Database'!J91)","v":1}]
[null,"2091900000111101",{"$f":"VLOOKUP($B92,'1.2 FY2012'!$B$5:$E$86,2,FALSE)","v":"Quarterly changes in current taxes"},{"$f":"VLOOKUP($B92,'1.2 FY2012'!$B$5:$E$86,3,FALSE)","v":111101},{"$f":"VLOOKUP($B92,'1.2 FY2012'!$B$5:$E$86,4,FALSE)","v":"Not assigned"},{"$f":"-SUMIF('1.1 FY2011'!$B:$B,'2.1 Database'!B92,'1.1 FY2011'!$F:$F)","v":0},{"$f":"-SUMIF('1.2 FY2012'!$B:$B,'2.1 Database'!B92,'1.2 FY2012'!$F:$F)","v":0},{"$f":"-SUMIF('1.3 FY2013'!$B:$B,'2.1 Database'!B92,'1.3 FY2013'!$F:$F)","v":0},null,0,{"$f":"+COUNTIF('2.2 P&L statement'!$B$4:$B$24,'2.1 Database'!J92)","v":0}]
[null,"2111111999111101",{"$f":"VLOOKUP($B93,'1.2 FY2012'!$B$5:$E$86,2,FALSE)","v":"Net income/(loss)"},{"$f":"VLOOKUP($B93,'1.2 FY2012'!$B$5:$E$86,3,FALSE)","v":111101},{"$f":"VLOOKUP($B93,'1.2 FY2012'!$B$5:$E$86,4,FALSE)","v":"Not assigned"},{"$f":"SUMIF('1.1 FY2011'!$B:$B,'2.1 Database'!B93,'1.1 FY2011'!$F:$F)","v":0},{"$f":"SUMIF('1.2 FY2012'!$B:$B,'2.1 Database'!B93,'1.2 FY2012'!$F:$F)","v":6073808.1600000001},{"$f":"SUMIF('1.3 FY2013'!$B:$B,'2.1 Database'!B93,'1.3 FY2013'!$F:$F)","v":-779290.47600000002},null,"Net Income",{"$f":"+COUNTIF('2.2 P&L statement'!$B$4:$B$24,'2.1 Database'!J93)","v":1}]
[null,"2024020000111111",{"$f":"+VLOOKUP($B94,'1.3 FY2013'!$B$5:$E$78,2,FALSE)","v":"Operating expenses for utilities"},{"$f":"+VLOOKUP($B94,'1.3 FY2013'!$B$5:$E$78,3,FALSE)","v":111111},{"$f":"+VLOOKUP($B94,'1.3 FY2013'!$B$5:$E$78,4,FALSE)","v":"External"},{"$f":"-SUMIF('1.1 FY2011'!$B:$B,'2.1 Database'!B94,'1.1 FY2011'!$F:$F)","v":0},{"$f":"-SUMIF('1.2 FY2012'!$B:$B,'2.1 Database'!B94,'1.2 FY2012'!$F:$F)","v":0},{"$f":"-SUMIF('1.3 FY2013'!$B:$B,'2.1 Database'!B94,'1.3 FY2013'!$F:$F)","v":-13691.949999999999},null,"Other operating expenses",{"$f":"+COUNTIF('2.2 P&L statement'!$B$4:$B$24,'2.1 Database'!J94)","v":1}]
[null,"20240900002185",{"$f":"+VLOOKUP($B95,'1.3 FY2013'!$B$5:$E$78,2,FALSE)","v":"R&D expenses"},{"$f":"+VLOOKUP($B95,'1.3 FY2013'!$B$5:$E$78,3,FALSE)","v":"2185"},{"$f":"+VLOOKUP($B95,'1.3 FY2013'!$B$5:$E$78,4,FALSE)","v":"Generco Green Projects GmbH"},{"$f":"-SUMIF('1.1 FY2011'!$B:$B,'2.1 Database'!B95,'1.1 FY2011'!$F:$F)","v":0},{"$f":"-SUMIF('1.2 FY2012'!$B:$B,'2.1 Database'!B95,'1.2 FY2012'!$F:$F)","v":0},{"$f":"-SUMIF('1.3 FY2013'!$B:$B,'2.1 Database'!B95,'1.3 FY2013'!$F:$F)","v":-192017.14499999996},null,"Other operating expenses",{"$f":"+COUNTIF('2.2 P&L statement'!$B$4:$B$24,'2.1 Database'!J95)","v":1}]
[null,"20240900002240",{"$f":"+VLOOKUP($B96,'1.3 FY2013'!$B$5:$E$78,2,FALSE)","v":"R&D expenses"},{"$f":"+VLOOKUP($B96,'1.3 FY2013'!$B$5:$E$78,3,FALSE)","v":"2240"},{"$f":"+VLOOKUP($B96,'1.3 FY2013'!$B$5:$E$78,4,FALSE)","v":"Greeny Germany GmbH"},{"$f":"-SUMIF('1.1 FY2011'!$B:$B,'2.1 Database'!B96,'1.1 FY2011'!$F:$F)","v":0},{"$f":"-SUMIF('1.2 FY2012'!$B:$B,'2.1 Database'!B96,'1.2 FY2012'!$F:$F)","v":0},{"$f":"-SUMIF('1.3 FY2013'!$B:$B,'2.1 Database'!B96,'1.3 FY2013'!$F:$F)","v":-375290.46599999996},null,"Other operating expenses",{"$f":"+COUNTIF('2.2 P&L statement'!$B$4:$B$24,'2.1 Database'!J96)","v":1}]
[null,"202409000017000",{"$f":"+VLOOKUP($B97,'1.3 FY2013'!$B$5:$E$78,2,FALSE)","v":"R&D expenses"},{"$f":"+VLOOKUP($B97,'1.3 FY2013'!$B$5:$E$78,3,FALSE)","v":17000},{"$f":"+VLOOKUP($B97,'1.3 FY2013'!$B$5:$E$78,4,FALSE)","v":"Generco Risk Management Ltd"},{"$f":"-SUMIF('1.1 FY2011'!$B:$B,'2.1 Database'!B97,'1.1 FY2011'!$F:$F)","v":0},{"$f":"-SUMIF('1.2 FY2012'!$B:$B,'2.1 Database'!B97,'1.2 FY2012'!$F:$F)","v":0},{"$f":"-SUMIF('1.3 FY2013'!$B:$B,'2.1 Database'!B97,'1.3 FY2013'!$F:$F)","v":-4920},null,"Other operating expenses",{"$f":"+COUNTIF('2.2 P&L statement'!$B$4:$B$24,'2.1 Database'!J97)","v":1}]
[null,"20604410001118",{"$f":"+VLOOKUP($B98,'1.3 FY2013'!$B$5:$E$78,2,FALSE)","v":"Other operative currency differences"},{"$f":"+VLOOKUP($B98,'1.3 FY2013'!$B$5:$E$78,3,FALSE)","v":"1118"},{"$f":"+VLOOKUP($B98,'1.3 FY2013'!$B$5:$E$78,4,FALSE)","v":"Gener Green LLC"},{"$f":"-SUMIF('1.1 FY2011'!$B:$B,'2.1 Database'!B98,'1.1 FY2011'!$F:$F)","v":0},{"$f":"-SUMIF('1.2 FY2012'!$B:$B,'2.1 Database'!B98,'1.2 FY2012'!$F:$F)","v":0},{"$f":"-SUMIF('1.3 FY2013'!$B:$B,'2.1 Database'!B98,'1.3 FY2013'!$F:$F)","v":0},null,"Other operating expenses",{"$f":"+COUNTIF('2.2 P&L statement'!$B$4:$B$24,'2.1 Database'!J98)","v":1}]
[null,"2060441000111111",{"$f":"+VLOOKUP($B99,'1.3 FY2013'!$B$5:$E$78,2,FALSE)","v":"Other operative currency differences"},{"$f":"+VLOOKUP($B99,'1.3 FY2013'!$B$5:$E$78,3,FALSE)","v":111111},{"$f":"+VLOOKUP($B99,'1.3 FY2013'!$B$5:$E$78,4,FALSE)","v":"External"},{"$f":"-SUMIF('1.1 FY2011'!$B:$B,'2.1 Database'!B99,'1.1 FY2011'!$F:$F)","v":0},{"$f":"-SUMIF('1.2 FY2012'!$B:$B,'2.1 Database'!B99,'1.2 FY2012'!$F:$F)","v":0},{"$f":"-SUMIF('1.3 FY2013'!$B:$B,'2.1 Database'!B99,'1.3 FY2013'!$F:$F)","v":1252.8369999999998},null,"Other operating expenses",{"$f":"+COUNTIF('2.2 P&L statement'!$B$4:$B$24,'2.1 Database'!J99)","v":1}]
[null,"20690100001006",{"$f":"+VLOOKUP($B100,'1.3 FY2013'!$B$5:$E$78,2,FALSE)","v":"Corporate recharges"},{"$f":"+VLOOKUP($B100,'1.3 FY2013'!$B$5:$E$78,3,FALSE)","v":1006},{"$f":"+VLOOKUP($B100,'1.3 FY2013'!$B$5:$E$78,4,FALSE)","v":"Generco Mining GmbH"},{"$f":"-SUMIF('1.1 FY2011'!$B:$B,'2.1 Database'!B100,'1.1 FY2011'!$F:$F)","v":0},{"$f":"-SUMIF('1.2 FY2012'!$B:$B,'2.1 Database'!B100,'1.2 FY2012'!$F:$F)","v":0},{"$f":"-SUMIF('1.3 FY2013'!$B:$B,'2.1 Database'!B100,'1.3 FY2013'!$F:$F)","v":0},null,"Recharges",{"$f":"+COUNTIF('2.2 P&L statement'!$B$4:$B$24,'2.1 Database'!J100)","v":1}]
[null,"2069020000111111",{"$f":"+VLOOKUP($B101,'1.3 FY2013'!$B$5:$E$78,2,FALSE)","v":"Reimbursements+compensation for damages"},{"$f":"+VLOOKUP($B101,'1.3 FY2013'!$B$5:$E$78,3,FALSE)","v":111111},{"$f":"+VLOOKUP($B101,'1.3 FY2013'!$B$5:$E$78,4,FALSE)","v":"External"},{"$f":"-SUMIF('1.1 FY2011'!$B:$B,'2.1 Database'!B101,'1.1 FY2011'!$F:$F)","v":0},{"$f":"-SUMIF('1.2 FY2012'!$B:$B,'2.1 Database'!B101,'1.2 FY2012'!$F:$F)","v":0},{"$f":"-SUMIF('1.3 FY2013'!$B:$B,'2.1 Database'!B101,'1.3 FY2013'!$F:$F)","v":61499.999999999993},null,"Other operating expenses",{"$f":"+COUNTIF('2.2 P&L statement'!$B$4:$B$24,'2.1 Database'!J101)","v":1}]
[null,"2069980000105",{"$f":"+VLOOKUP($B102,'1.3 FY2013'!$B$5:$E$78,2,FALSE)","v":"Other income"},{"$f":"+VLOOKUP($B102,'1.3 FY2013'!$B$5:$E$78,3,FALSE)","v":105},{"$f":"+VLOOKUP($B102,'1.3 FY2013'!$B$5:$E$78,4,FALSE)","v":"Generco Healthcare Ltd"},{"$f":"-SUMIF('1.1 FY2011'!$B:$B,'2.1 Database'!B102,'1.1 FY2011'!$F:$F)","v":0},{"$f":"-SUMIF('1.2 FY2012'!$B:$B,'2.1 Database'!B102,'1.2 FY2012'!$F:$F)","v":0},{"$f":"-SUMIF('1.3 FY2013'!$B:$B,'2.1 Database'!B102,'1.3 FY2013'!$F:$F)","v":30913.425999999996},null,"Other income",{"$f":"+COUNTIF('2.2 P&L statement'!$B$4:$B$24,'2.1 Database'!J102)","v":1}]
[null,"2070600000105",{"$f":"+VLOOKUP($B103,'1.3 FY2013'!$B$5:$E$78,2,FALSE)","v":"Leasings"},{"$f":"+VLOOKUP($B103,'1.3 FY2013'!$B$5:$E$78,3,FALSE)","v":105},{"$f":"+VLOOKUP($B103,'1.3 FY2013'!$B$5:$E$78,4,FALSE)","v":"Generco Healthcare Ltd"},{"$f":"-SUMIF('1.1 FY2011'!$B:$B,'2.1 Database'!B103,'1.1 FY2011'!$F:$F)","v":0},{"$f":"-SUMIF('1.2 FY2012'!$B:$B,'2.1 Database'!B103,'1.2 FY2012'!$F:$F)","v":0},{"$f":"-SUMIF('1.3 FY2013'!$B:$B,'2.1 Database'!B103,'1.3 FY2013'!$F:$F)","v":1423120},null,"Leasing",{"$f":"+COUNTIF('2.2 P&L statement'!$B$4:$B$24,'2.1 Database'!J103)","v":1}]
[null,"207110000088",{"$f":"+VLOOKUP($B104,'1.3 FY2013'!$B$5:$E$78,2,FALSE)","v":"Insurance expenses"},{"$f":"+VLOOKUP($B104,'1.3 FY2013'!$B$5:$E$78,3,FALSE)","v":88},{"$f":"+VLOOKUP($B104,'1.3 FY2013'!$B$5:$E$78,4,FALSE)","v":"Generco Ltd"},{"$f":"-SUMIF('1.1 FY2011'!$B:$B,'2.1 Database'!B104,'1.1 FY2011'!$F:$F)","v":0},{"$f":"-SUMIF('1.2 FY2012'!$B:$B,'2.1 Database'!B104,'1.2 FY2012'!$F:$F)","v":0},{"$f":"-SUMIF('1.3 FY2013'!$B:$B,'2.1 Database'!B104,'1.3 FY2013'!$F:$F)","v":-584.66},null,"Other operating expenses",{"$f":"+COUNTIF('2.2 P&L statement'!$B$4:$B$24,'2.1 Database'!J104)","v":1}]
[null,"2071209100111111",{"$f":"+VLOOKUP($B105,'1.3 FY2013'!$B$5:$E$78,2,FALSE)","v":"Repairs/Maintenance costs"},{"$f":"+VLOOKUP($B105,'1.3 FY2013'!$B$5:$E$78,3,FALSE)","v":111111},{"$f":"+VLOOKUP($B105,'1.3 FY2013'!$B$5:$E$78,4,FALSE)","v":"External"},{"$f":"-SUMIF('1.1 FY2011'!$B:$B,'2.1 Database'!B105,'1.1 FY2011'!$F:$F)","v":0},{"$f":"-SUMIF('1.2 FY2012'!$B:$B,'2.1 Database'!B105,'1.2 FY2012'!$F:$F)","v":0},{"$f":"-SUMIF('1.3 FY2013'!$B:$B,'2.1 Database'!B105,'1.3 FY2013'!$F:$F)","v":-1352.9999999999998},null,"Other operating expenses",{"$f":"+COUNTIF('2.2 P&L statement'!$B$4:$B$24,'2.1 Database'!J105)","v":1}]
[null,"2082110000111101",{"$f":"+VLOOKUP($B106,'1.3 FY2013'!$B$5:$E$78,2,FALSE)","v":"Impairment of participation"},{"$f":"+VLOOKUP($B106,'1.3 FY2013'!$B$5:$E$78,3,FALSE)","v":111101},{"$f":"+VLOOKUP($B106,'1.3 FY2013'!$B$5:$E$78,4,FALSE)","v":"Not assigned"},{"$f":"-SUMIF('1.1 FY2011'!$B:$B,'2.1 Database'!B106,'1.1 FY2011'!$F:$F)","v":0},{"$f":"-SUMIF('1.2 FY2012'!$B:$B,'2.1 Database'!B106,'1.2 FY2012'!$F:$F)","v":0},{"$f":"-SUMIF('1.3 FY2013'!$B:$B,'2.1 Database'!B106,'1.3 FY2013'!$F:$F)","v":0},null,0,{"$f":"+COUNTIF('2.2 P&L statement'!$B$4:$B$24,'2.1 Database'!J106)","v":0}]
[null,"2111111997111101",{"$f":"+VLOOKUP($B107,'1.3 FY2013'!$B$5:$E$78,2,FALSE)","v":"Offset segments (tech.)"},{"$f":"+VLOOKUP($B107,'1.3 FY2013'!$B$5:$E$78,3,FALSE)","v":111101},{"$f":"+VLOOKUP($B107,'1.3 FY2013'!$B$5:$E$78,4,FALSE)","v":"Not assigned"},{"$f":"-SUMIF('1.1 FY2011'!$B:$B,'2.1 Database'!B107,'1.1 FY2011'!$F:$F)","v":0},{"$f":"-SUMIF('1.2 FY2012'!$B:$B,'2.1 Database'!B107,'1.2 FY2012'!$F:$F)","v":0},{"$f":"-SUMIF('1.3 FY2013'!$B:$B,'2.1 Database'!B107,'1.3 FY2013'!$F:$F)","v":0},null,0,{"$f":"+COUNTIF('2.2 P&L statement'!$B$4:$B$24,'2.1 Database'!J107)","v":0}]
[null,null,null,null,null,null,null,null,null,"x","x"]

{"sheet":"2.2 P&L statement","index":8,"n_rows":33,"n_cols":10,"rows_kept":33,"cut":false,"hidden":false,"merged":[]}
[null,"P&L statement"]
[]
[null,"EUR in millions","FY11","FY12","FY13",null,"Var%\nFY11-FY12","Var%\nFY12-FY13",null,"Formula for calculating y-o-y % variations:"]
[null,"Net Sales",{"$f":"+SUMIF('2.1 Database'!$J:$J,'2.2 P&L statement'!$B4,'2.1 Database'!F:F)/1000000","v":14.500341000000001},{"$f":"+SUMIF('2.1 Database'!$J:$J,'2.2 P&L statement'!$B4,'2.1 Database'!G:G)/1000000","v":16.148295364999999},{"$f":"+SUMIF('2.1 Database'!$J:$J,'2.2 P&L statement'!$B4,'2.1 Database'!H:H)/1000000","v":15.047803019},null,{"$f":"+IF(ISERROR((D4/C4)-1),\"n.a.\",IF(((D4/C4)-1)>1,\">100.0%\",IF(((D4/C4)-1)<-1,\"<-100.0%\",((D4/C4)-1))))","v":0.11364935245315944},{"$f":"+IF(ISERROR((E4/D4)-1),\"n.a.\",IF(((E4/D4)-1)>1,\">100.0%\",IF(((E4/D4)-1)<-1,\"<-100.0%\",((E4/D4)-1))))","v":-6.8149134080444096E-2},null,"IF(ISERROR((D4/C4)-1),\"n.a.\",IF(((D4/C4)-1)>1,\">100.0%\",IF(((D4/C4)-1)<-1,\"<-100.0%\",((D4/C4)-1))))"]
[null,"Other revenues",{"$f":"+SUMIF('2.1 Database'!$J:$J,'2.2 P&L statement'!$B5,'2.1 Database'!F:F)/1000000","v":4.7948561920000001},{"$f":"+SUMIF('2.1 Database'!$J:$J,'2.2 P&L statement'!$B5,'2.1 Database'!G:G)/1000000","v":6.9602176449999993},{"$f":"+SUMIF('2.1 Database'!$J:$J,'2.2 P&L statement'!$B5,'2.1 Database'!H:H)/1000000","v":6.3736175140000002},null,{"$f":"+IF(ISERROR((D5/C5)-1),\"n.a.\",IF(((D5/C5)-1)>1,\">100.0%\",IF(((D5/C5)-1)<-1,\"<-100.0%\",((D5/C5)-1))))","v":0.45160091696030569},{"$f":"+IF(ISERROR((E5/D5)-1),\"n.a.\",IF(((E5/D5)-1)>1,\">100.0%\",IF(((E5/D5)-1)<-1,\"<-100.0%\",((E5/D5)-1))))","v":-8.4278992542911935E-2}]
[null,"Recharges",{"$f":"+SUMIF('2.1 Database'!$J:$J,'2.2 P&L statement'!$B6,'2.1 Database'!F:F)/1000000","v":3.2200542519999997},{"$f":"+SUMIF('2.1 Database'!$J:$J,'2.2 P&L statement'!$B6,'2.1 Database'!G:G)/1000000","v":2.9240919949999999},{"$f":"+SUMIF('2.1 Database'!$J:$J,'2.2 P&L statement'!$B6,'2.1 Database'!H:H)/1000000","v":4.8931777299999997},null,-9.1912195832158816E-2,0.67340074743441836]
[null,"Total Revenues",{"$f":"+SUM(C4:C6)","v":22.515251444},{"$f":"+SUM(D4:D6)","v":26.032605005000001},{"$f":"+SUM(E4:E6)","v":26.314598263000001},null,0.15622093183140207,1.0832310402506318E-2]
[null,"Direct costs",{"$f":"+SUMIF('2.1 Database'!$J:$J,'2.2 P&L statement'!$B8,'2.1 Database'!F:F)/1000000","v":-4.4289117640000004},{"$f":"+SUMIF('2.1 Database'!$J:$J,'2.2 P&L statement'!$B8,'2.1 Database'!G:G)/1000000","v":-5.4631888250000005},{"$f":"+SUMIF('2.1 Database'!$J:$J,'2.2 P&L statement'!$B8,'2.1 Database'!H:H)/1000000","v":-5.6741520669999996},null,0.23352848647991253,3.861540370609462E-2]
[null,"Gross Margin",{"$f":"+SUM(C7:C8)","v":18.086339680000002},{"$f":"+SUM(D7:D8)","v":20.569416180000001},{"$f":"+SUM(E7:E8)","v":20.640446195999999},null,0.13729016174266606,3.4531858064625887E-3]
[null,"Other operating expenses",{"$f":"+SUMIF('2.1 Database'!$J:$J,'2.2 P&L statement'!$B10,'2.1 Database'!F:F)/1000000","v":-3.3966489799999997},{"$f":"+SUMIF('2.1 Database'!$J:$J,'2.2 P&L statement'!$B10,'2.1 Database'!G:G)/1000000","v":-3.7048433449999996},{"$f":"+SUMIF('2.1 Database'!$J:$J,'2.2 P&L statement'!$B10,'2.1 Database'!H:H)/1000000","v":-6.6874830379999999},null,9.0734829184498045E-2,0.80506499607475335]
[null,"Personnel expenses",{"$f":"+SUMIF('2.1 Database'!$J:$J,'2.2 P&L statement'!$B11,'2.1 Database'!F:F)/1000000","v":-6.17073904},{"$f":"+SUMIF('2.1 Database'!$J:$J,'2.2 P&L statement'!$B11,'2.1 Database'!G:G)/1000000","v":-8.0718589449999989},{"$f":"+SUMIF('2.1 Database'!$J:$J,'2.2 P&L statement'!$B11,'2.1 Database'!H:H)/1000000","v":-5.8358881759999992},null,0.30808625882192531,-0.27700815688622027]
[null,"Leasing",{"$f":"+SUMIF('2.1 Database'!$J:$J,'2.2 P&L statement'!$B12,'2.1 Database'!F:F)/1000000","v":-1.127445872},{"$f":"+SUMIF('2.1 Database'!$J:$J,'2.2 P&L statement'!$B12,'2.1 Database'!G:G)/1000000","v":-1.0553814750000001},{"$f":"+SUMIF('2.1 Database'!$J:$J,'2.2 P&L statement'!$B12,'2.1 Database'!H:H)/1000000","v":1.596053449},null,-6.391827651305626E-2,"<-100.0%"]
[null,"Services",{"$f":"+SUMIF('2.1 Database'!$J:$J,'2.2 P&L statement'!$B13,'2.1 Database'!F:F)/1000000","v":-2.5430882079999995},{"$f":"+SUMIF('2.1 Database'!$J:$J,'2.2 P&L statement'!$B13,'2.1 Database'!G:G)/1000000","v":-1.837786345},{"$f":"+SUMIF('2.1 Database'!$J:$J,'2.2 P&L statement'!$B13,'2.1 Database'!H:H)/1000000","v":-1.9549839309999999},null,-0.27734069969782171,6.3771061483210545E-2]
[null,"Travel costs",{"$f":"+SUMIF('2.1 Database'!$J:$J,'2.2 P&L statement'!$B14,'2.1 Database'!F:F)/1000000","v":-1.8135250039999999},{"$f":"+SUMIF('2.1 Database'!$J:$J,'2.2 P&L statement'!$B14,'2.1 Database'!G:G)/1000000","v":-2.3932591899999998},{"$f":"+SUMIF('2.1 Database'!$J:$J,'2.2 P&L statement'!$B14,'2.1 Database'!H:H)/1000000","v":-2.5144318869999998},null,0.31967256294857238,5.0630829082912721E-2]
[null,"Other income",{"$f":"+SUMIF('2.1 Database'!$J:$J,'2.2 P&L statement'!$B15,'2.1 Database'!F:F)/1000000","v":5.7221999999999995E-5},{"$f":"+SUMIF('2.1 Database'!$J:$J,'2.2 P&L statement'!$B15,'2.1 Database'!G:G)/1000000","v":-7.3574899999999995E-3},{"$f":"+SUMIF('2.1 Database'!$J:$J,'2.2 P&L statement'!$B15,'2.1 Database'!H:H)/1000000","v":4.678542799999999E-2},null,"<-100.0%","<-100.0%"]
[null,"Capitalized costs",{"$f":"+SUMIF('2.1 Database'!$J:$J,'2.2 P&L statement'!$B16,'2.1 Database'!F:F)/1000000","v":5.2683321979999995},{"$f":"+SUMIF('2.1 Database'!$J:$J,'2.2 P&L statement'!$B16,'2.1 Database'!G:G)/1000000","v":0.74482694999999999},{"$f":"+SUMIF('2.1 Database'!$J:$J,'2.2 P&L statement'!$B16,'2.1 Database'!H:H)/1000000","v":0},null,-0.85862187082986985,-1]
[null,"EBITDA",{"$f":"+SUM(C9:C16)","v":8.3032819960000026},{"$f":"+SUM(D9:D16)","v":4.2437563400000018},{"$f":"+SUM(E9:E16)","v":5.2904980409999993},null,-0.48890615276653548,0.24665452423217982]
[null,"D&A",{"$f":"+SUMIF('2.1 Database'!$J:$J,'2.2 P&L statement'!$B18,'2.1 Database'!F:F)/1000000","v":-2.045243514},{"$f":"+SUMIF('2.1 Database'!$J:$J,'2.2 P&L statement'!$B18,'2.1 Database'!G:G)/1000000","v":-2.0440058150000002},{"$f":"+SUMIF('2.1 Database'!$J:$J,'2.2 P&L statement'!$B18,'2.1 Database'!H:H)/1000000","v":-1.8883615140000001},null,-6.0515972378227811E-4,-7.6146701666795491E-2]
[null,"EBIT",{"$f":"+SUM(C17:C18)","v":6.2580384820000026},{"$f":"+SUM(D17:D18)","v":2.1997505250000016},{"$f":"+SUM(E17:E18)","v":3.4021365269999992},null,-0.64849201050342775,0.54660107513782585]
[null,"Financial items",{"$f":"+SUMIF('2.1 Database'!$J:$J,'2.2 P&L statement'!$B20,'2.1 Database'!F:F)/1000000","v":-2.8426923660000001},{"$f":"+SUMIF('2.1 Database'!$J:$J,'2.2 P&L statement'!$B20,'2.1 Database'!G:G)/1000000","v":-2.7107469200000001},{"$f":"+SUMIF('2.1 Database'!$J:$J,'2.2 P&L statement'!$B20,'2.1 Database'!H:H)/1000000","v":-2.250707829},null,-4.6415661285805099E-2,-0.16970934748862498]
[null,"Extraordinary items",{"$f":"+SUMIF('2.1 Database'!$J:$J,'2.2 P&L statement'!$B21,'2.1 Database'!F:F)/1000000","v":-2.2762999999999999E-2},{"$f":"+SUMIF('2.1 Database'!$J:$J,'2.2 P&L statement'!$B21,'2.1 Database'!G:G)/1000000","v":-4.5786198000000002},{"$f":"+SUMIF('2.1 Database'!$J:$J,'2.2 P&L statement'!$B21,'2.1 Database'!H:H)/1000000","v":-7.1731959999999989E-3},null,">100.0%",-0.99843332787754069]
[null,"EBT",{"$f":"+SUM(C19:C21)","v":3.3925831160000026},{"$f":"+SUM(D19:D21)","v":-5.0896161949999987},{"$f":"+SUM(E19:E21)","v":1.1442555019999991},null,"<-100.0%","<-100.0%"]
[null,"Taxes",{"$f":"+SUMIF('2.1 Database'!$J:$J,'2.2 P&L statement'!$B23,'2.1 Database'!F:F)/1000000","v":-0.48846512199999997},{"$f":"+SUMIF('2.1 Database'!$J:$J,'2.2 P&L statement'!$B23,'2.1 Database'!G:G)/1000000","v":-0.98419196500000017},{"$f":"+SUMIF('2.1 Database'!$J:$J,'2.2 P&L statement'!$B23,'2.1 Database'!H:H)/1000000","v":-0.36496502599999997},null,">100.0%",-0.62917292664546398]
[null,"Net Income",{"$f":"+SUM(C22:C23)","v":2.9041179940000026},{"$f":"+SUM(D22:D23)","v":-6.0738081599999987},{"$f":"+SUM(E22:E23)","v":0.77929047599999923},null,"<-100.0%","<-100.0%"]
[]
[null,"Gross Margin %",{"$f":"C9/C7","v":0.80329281353949789},{"$f":"D9/D7","v":0.79014052477841912},{"$f":"E9/E7","v":0.78437246085651935}]
[null,"EBITDA %",{"$f":"C17/C7","v":0.36878477758296191},{"$f":"D17/D7","v":0.16301696811306118},{"$f":"E17/E7","v":0.20104802619916018}]
[null,"EBIT %",{"$f":"C19/C7","v":0.2779466397506159},{"$f":"D19/D7","v":8.4499823378317393E-2},{"$f":"E19/E7","v":0.12928704033394345}]
[]
[]
[]
[null,"Net income",{"$f":"+SUMIF('2.1 Database'!$J:$J,'2.2 P&L statement'!$B32,'2.1 Database'!F:F)/1000000","v":-2.9041179939999986},{"$f":"+SUMIF('2.1 Database'!$J:$J,'2.2 P&L statement'!$B32,'2.1 Database'!G:G)/1000000","v":6.0738081600000005},{"$f":"+SUMIF('2.1 Database'!$J:$J,'2.2 P&L statement'!$B32,'2.1 Database'!H:H)/1000000","v":-0.77929047600000001}]
[null,null,{"$f":"+ROUND(C24+C32,9)","v":0},{"$f":"+D24+D32","v":0},{"$f":"+E24+E32","v":0}]

{"sheet":"3. Charts -->","index":9,"n_rows":12,"n_cols":2,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"3. Charts -->"]

{"sheet":"3.1 Column stacked chart","index":10,"n_rows":12,"n_cols":10,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
[null,"Column stacked chart"]
[]
[null,null,"FY11","FY12","FY13"]
[null,{"$f":"'[1]2.2 P&L statement'!B4","v":"Net Sales"},{"$f":"'2.2 P&L statement'!C4","v":14.500341000000001},{"$f":"'2.2 P&L statement'!D4","v":16.148295364999999},{"$f":"'2.2 P&L statement'!E4","v":15.047803019}]
[null,{"$f":"'[1]2.2 P&L statement'!B5","v":"Other revenues"},{"$f":"'2.2 P&L statement'!C5","v":4.7948561920000001},{"$f":"'2.2 P&L statement'!D5","v":6.9602176449999993},{"$f":"'2.2 P&L statement'!E5","v":6.3736175140000002}]
[null,{"$f":"'[1]2.2 P&L statement'!B6","v":"Recharges"},{"$f":"'2.2 P&L statement'!C6","v":3.2200542519999997},{"$f":"'2.2 P&L statement'!D6","v":2.9240919949999999},{"$f":"'2.2 P&L statement'!E6","v":4.8931777299999997}]
[null,{"$f":"'[1]2.2 P&L statement'!B27","v":"Gross Margin %"},{"$f":"'2.2 P&L statement'!C26","v":0.80329281353949789},{"$f":"'2.2 P&L statement'!D26","v":0.79014052477841912},{"$f":"'2.2 P&L statement'!E26","v":0.78437246085651935}]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"a"," "]

{"sheet":"3.2 Dougnut chart","index":11,"n_rows":6,"n_cols":5,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
[null,"Doughnut chart"]
[]
[null,null,{"$f":"'[1]Column stacked chart'!C3","v":"FY11"},{"$f":"'[1]Column stacked chart'!D3","v":"FY12"},{"$f":"'[1]Column stacked chart'!E3","v":"FY13"}]
[null,{"$f":"'2.2 P&L statement'!B4","v":"Net Sales"},{"$f":"'2.2 P&L statement'!C4","v":14.500341000000001},{"$f":"'2.2 P&L statement'!D4","v":16.148295364999999},{"$f":"'2.2 P&L statement'!E4","v":15.047803019}]
[null,{"$f":"'2.2 P&L statement'!B5","v":"Other revenues"},{"$f":"'2.2 P&L statement'!C5","v":4.7948561920000001},{"$f":"'2.2 P&L statement'!D5","v":6.9602176449999993},{"$f":"'2.2 P&L statement'!E5","v":6.3736175140000002}]
[null,{"$f":"'2.2 P&L statement'!B6","v":"Recharges"},{"$f":"'2.2 P&L statement'!C6","v":3.2200542519999997},{"$f":"'2.2 P&L statement'!D6","v":2.9240919949999999},{"$f":"'2.2 P&L statement'!E6","v":4.8931777299999997}]

{"sheet":"3.3 Area & line chart","index":12,"n_rows":6,"n_cols":5,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
[null,"Area & Line chart"]
[]
[]
[null,null,"FY11","FY12","FY13"]
[null,"Revenues",{"$f":"'[1]2.2 P&L statement'!C7","v":22.515251444},{"$f":"'[1]2.2 P&L statement'!D7","v":26.032605005000001},{"$f":"'[1]2.2 P&L statement'!E7","v":26.314598263000001}]
[null,"Gross Margin %",{"$f":"'[1]2.2 P&L statement'!C27","v":0.80329281353949789},{"$f":"'[1]2.2 P&L statement'!D27","v":0.79014052477841912},{"$f":"'[1]2.2 P&L statement'!E27","v":0.78437246085651935}]

{"sheet":"3.4 Bridge Chart","index":13,"n_rows":1048571,"n_cols":6,"rows_kept":4500,"cut":true,"hidden":false,"merged":[],"bounds":{"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0}}
[null,"Bridge chart"]
[]
[]
[null,"EBITDA FY12",{"$f":"'2.2 P&L statement'!D17","v":4.2437563400000018}]
[null,"Change in Revenues",{"$f":"'2.2 P&L statement'!E7-'2.2 P&L statement'!D7","v":0.28199325799999997}]
[null,"Change in Variable costs",{"$f":"+'2.2 P&L statement'!E8-'2.2 P&L statement'!D8","v":-0.21096324199999916}]
[null,"Change in Opex",{"$f":"SUM('2.2 P&L statement'!E10:E16)-SUM('2.2 P&L statement'!D10:D16)","v":0.97571168500000027}]
[null,"EBITDA FY13",{"$f":"'2.2 P&L statement'!E17","v":5.2904980409999993}]
[]
[null,"Check",{"$f":"SUM(C4:C7)-C8","v":0}]
[]
[]
[]
[null,"EBITDA FY12","Change in Revenues","Change in Variable costs","Change in Opex","EBITDA FY13"]
[null,{"$f":"C4","v":4.2437563400000018},{"$f":"+B15","v":4.2437563400000018},{"$f":"+C15+C16+C6","v":4.3147863560000026},{"$f":"+D15","v":4.3147863560000026},{"$f":"+E15+E16","v":5.2904980410000029}]
[null,0,{"$f":"+C5","v":0.28199325799999997},{"$f":"-C6","v":0.21096324199999916},{"$f":"+C7","v":0.97571168500000027}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,{"$f":"C4","v":4.2437563400000018},{"$f":"B1048568","v":4.2437563400000018},{"$f":"C1048568+C1048569+C6","v":4.3147863560000026},{"$f":"D1048568","v":4.3147863560000026}]
[null,0,{"$f":"C5","v":0.28199325799999997},{"$f":"-C6","v":0.21096324199999916},{"$f":"C7","v":0.97571168500000027},{"$f":"E1048569+E1048568","v":5.2904980410000029}]
[]
[null,"EBITDA \nFY12","Change in Revenues",{"$f":"B6","v":"Change in Variable costs"},"Change in\nOpex","EBITDA FY13"]